|I'm trying to identify costs based on the hours of a delay/event. I need to take to total amount of time (in hours and minutes) and multiply by a given rate. |
For example I need to convert the 7 hours 10 minutes, into 7.167, or 5 hours and 45 minutes into 5.75, etc.
Currently I have:
Start Time: Cell E3 = 07:00
End Time: Cell F3 = 14:30
Total Time: Cell G3 = F3-E3 (Which produces a value of 7:30 instead of 7.5)
Rate: Cell H3 = 50
Total Cost: Cell I3 = G3 * H3 (Which produces a number of 15.63??)
Finally I am using Excel 2010.
message edited by tgosman