PPRuNe Forums - View Single Post - Excel Time Calculation
View Single Post
Old 29th Jul 2005, 12:37
  #5 (permalink)  
MadsDad

(a bear of little brain)
 
Join Date: Aug 2001
Location: 51 10 03.70N 2 58 37.15W
Age: 75
Posts: 273
Likes: 0
Received 0 Likes on 0 Posts
Bre I should have put some comment about the 1440, didn't think to. Also the fact that the 'hh:mm' restricts the time to hours and minutes.

And, of course, if anyone wasnts to work out the cost/second the time format would need to be 'hh:mm:ss' (so now you've got seconds as well) and the multiplication would need to be (pause to use calculator) '*86400'.

(And if you want it per day, leave off the '*1440').
MadsDad is offline