I am working with a bi-weekly timesheet that calculates total hours in
decimal format. I need to calculate the overtime after 8 hours in a day.

C10 shows a clock in time of 8:39
D10 shows a clock out time of 13:00
E10 shows a clock in time of 13:30
F10 shows a clock out time of 17:14
formula in G10 is as follows --- =(D10-C10+F10-E10)*24 giving a total of
8.08 hrs worked
H10 needs to show ONLY the .08 of the 8.08 AND is there a way to make the
hours in G10 not show hrs in excess of 8.00 at the same time?

Your help is appreciated!!
Dreamweavn