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

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History