I am working to re-design the emergency timesheets for those deployed for
Hurricane duty. They work 12 hour days. Each location gives a Tour of Duty
which will determine how overtime is broken down. I have scheduled overtime,
unschedule overtime, and overtime with night differential as well as the
regular 8 hour day. I need to set something up that will allow them to input
their set TOD (i.e. 0600-1830) and then the clock hours they work (checking
in and out for lunch) and be able to break out the hours from there in the
appropriate columns. For instance - if a TOD is 0600-1830 - the hours would
break out as follows for M-F:

0600-1200 - 6 RG
1230-1530 - 3 RG
1530-1800 - 3.5 OS
1800-1830 - .5 OS/ND

Now lets say they decided to work until 2100 that night. I would have to
then add:
1830-2100 2.5 OU

So - the TOD determines the break out of the OT hours, but the clock hours
determine the amounts and if any Unscheduled Overtime is necessary.

How would I set this up?