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.

Help!!!

message edited by tgosman

This formula will convert a time to it's decimal equivalent: =(F3-INT(F3))*24

This will calculate your time difference in a single cell:

=(F3-INT(F3))*24-(E3-INT(E3))*24

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

That works, thank you so very much!

I'm curious to know why it works, so that I can apply this type of solution as it may arise. If you have time, any chance you could enlighten me on this? Maybe, just why the *24 seems to be necessary to make the calc work?

Thanks either way!

See here for how Excel stores Dates and Times internally: http://www.ozgrid.com/Excel/ExcelDa...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History