Need help with reg hrs and overtime totals please

[PeterM]

I have a timesheet that I wished I could figure out the regular time and the
overtime on. The sequence in which order I write makes no difference, I
mean if lunch has to be at the end, it doesn't matter. Here is the way I
have it now. Row 2 is the date, and column B=Time in 09:00, C=Time out
05:30, D=1/2 lunch (don't know how to write it, sometimes it is 1 hr lunch),
E=Time in 12:30 (or 01:00), F=Time out, G=Total Regular hrs, H=Overtime. The
overtime is figured if the time is over 8 hrs. If one of you wonderful
readers could help me with this, I would really really appreciate it. Many
many thanks..........Peter

 

[Gary Brown]

Not sure why you need both column D and Columns C and E. Either D or C and
E are sufficient. Below used columns c and e.
HTH,
Gary Brown

Regular Time formula: Column G
=IF((C2-B2+F2-E2)*24>8,8,(C2-B2+F2-E2)*24)
Overtime formula: Column H
=MAX(((C2-B2+F2-E2)*24)-8,0)

 

[PeterM]

Thank you Gary, I probably don't need the extra columns, I was just copying
the form Human resources were using, but as long as I can sign the form the
way you have it, and it will show what they want, I'm home free. I will try
it later on my laptop. I really really appreciate you for this help. I would
have never never figured this out. What a nice person you are Gary.
....................Peter

 

[PeterM]

Hello Gary, I have another question about the wonderful work you done to
help. Everything worked swell. Is there a way if I start earlier in the day,
lets say 8:00 instead of 9:00, it doesn't seem to change the total hours,
as well as if I take a longer lunch, that it will add or subtract the time?
Could I please send you this small sheet so you can look at
it?................Peter