I'm trying to calculate the number of hours worked when it crosses over to a new day. For instance, 15:00 to 2 a.m. the next day. When I use the formula +b2-a2+if(a2>b2,1) the result is .54. Can anyone tell me what I can do to resolve this and come up with the correct value of 12 hours? I've also tried using 24 in place of the 1 and it gives me the same result.

Please help!

Hi,

Have a look at this link

http://www.excelforum.com/excel-worksheet-functions/580820-timesheet-calculation.html

Or you could check out Chip Pearson website

http://www.cpearson.com/excel/overtime.htm

This might help

=(A3-A2+(A3<A2))*24

Format as Number and 2 Decimal places


VBA Noob

__________________
_________________________________________


Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters

Please remember to wrap code.

Forum Rules

Please add to your signature if you found this link helpful. Excel links !!!

I got the help I needed from the Cpearson.com site.

Thanks for your help!

Glad you got it

VBA Noob

__________________
_________________________________________


Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters

Please remember to wrap code.

Forum Rules

Please add to your signature if you found this link helpful. Excel links !!!