Difference between two times - thank you!!

Hello everyone

I would really appreciate your help

I have a client who weants to work out the total number of hours (not minutes) between two times. I have managed to do that with no problem using the formula =IF(A2>B2,B2-A2+1,A2+B2). However, this is where the problem starts.

They want to multiply the number of hours with the number of men on the job, but the answer is wrong, and I cannot understand why. I have checked the formnat of the cell and changed it to see if that is the problem, but without success.

I have copied it below

Time in Time out No hours No of Men Total Man Hours
12:00 03:00 15 2 6
14:00 18:00 4 7 4


Any help would be really apprciated

Thank you
Lynne

format cell as general then "time*24*men" will give the number of man hours in your example c1*d1*24

duplicate post..tut tut
answer already given
but just a reminder hours*men*24 cell formatted general will give answer you want

I am really sorry about the duplcate. Did not see one on the first post.

Tried what you said (tried before) but unsuccessful.

I got the answer 1.25 when I formatted it as General, ie 15 hours * 2 men

Completely baffled!

Help please (no more duplicates - promise)

How do I mark my question as solved. Have looked around, but cannot see how I do it

Thanks
Lynne

from here
http://www.exceltip.com/st/Multiplyi...bers./802.html

why must Hours x Rate be multiplied by 24? Excel treats time formats quite differently than regular numbers. One day = one whole time unit, therefore one hour = 1/24th of a whole unit, and we must multiply hours by 24 to achieve whole units of time