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 !!!