Skip to Content
0
Former Member
Jan 11, 2012 at 11:12 PM

How do I identify overtime hours once sum of hours exceeds 40?

238 Views

Hi,

I'm creating an overtime report and need to identify which hours on any given day represent regular hours and which represent overtime hours.

A "week" runs from Sunday to Saturday. I have employee timecard hours for each day of the week. I want to show a record for each day and if the hours to that point constitute regular or overtime hours. So, it would look something like:

Employee: Joe Bison

Week beginning: January 8, 2012

Reg Hours O/T Hours

January 8, 2012 14 0

January 9, 2012 12 0

January 10, 2012 14 2

January 11, 2012 0 8

January 12, 2012 0 11

January 13, 2012 0 8

January 14, 2012 0 9

Totals 40 38

The count resets at the beginning of each week. I know how to grab the hours for each day and total for a week. I just don't know how to run an ongoing sum to evaluate, at each day, if 40 hours has been reached yet and, if so, that the hours above that need to be put in the Overtime column. And note, of the 16 hours the employee worked on January 10, he hit the 40 hour threshold at the first 14 hours....so , all hours after that need to be recognized as overtime hours.

I hope this makes sense. Any help is much appreciated!

Mark