See Chip Pearson's site.
http://www.cpearson.com/excel/overtime.htm

"Dreamweavn via OfficeKB.com" wrote in message
...
Thanks for the quick response! The following does not allow just 8.00 to
appear in G10. It still shows 8.08.

=MAX(8,(D10-C10+F10-E10)*24)

I should have thought a step ahead ...calculating the day itself is fine
but to actaully figure overtime for hours over 40 this does not work, my
fault on that. Can you tell me how to get the following...

G13 shows the total for week 1 (in this case 24.0)
H13 shows the OT total for week 1 (in this case .43)

Of course you can now see why I should have thought a step ahead. OT is
not
valid if the hrs worked was only 24, however, lets say the hours were
40.43. How do I get G13 to show 40 total and H13 to show the remaining .43
OT total but NOT show the .43 if G13 is not over 40?

Dreamweavn