Time sheets

**itfitz98** · 06-09-2009, 09:37 PM

Hi:

I need a formula that will calculate time for me for employees. I have most of it figured out, but what I need it to do is if the time total is over 8 hours to leave the regulat time at 8 and put the rest of it in the over time column.

**timfu** · 06-09-2009, 10:41 PM

It seems can be open,Please help upload again:-)

**martindwilson** · 06-09-2009, 10:45 PM

in g20
=MIN(8,((F20-C20-(E20-D20))*24))
in g21
=((F20-C20-(E20-D20))*24)-G20
format cells as general
this gives real hours which can be used in calculations