So I'm building a spreadsheet where I need to calculate the operating cost per hour per route for a plane.
So in simple terms the formula would be column A (duration of flight) times column B (cost to operate aircraft per hour) = cost for flying the route
The problem is that I can't figure out for the life of me (short of converting hours to decimal format) how to make excel multiply the time in regular time format correctly to get the correct results.
A sample formula that I'm trying to do:
1:30hrs x $850= $38 (according to excel, WTF?!?)
The A column is selected to be in time format.
If i change the hours to normal general decimal format then excel gives me the right answer:
1.5hrs x $850 = $1275
I've searched like crazy on the help system and on google and cant find an answer.
I need to use non decimal format times for a presentation. Any ideas?
Using office 2007 by the way
[Edited 2010-02-18 14:42:49]