Thanks for the help but it doesn't calculate. Perhaps I did not explain well enough. I want the total hours split (regarless of code) to reflect the following:
Example 1:
19 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
7 hours -double overtime (time over 12 hours in a 24 hour period)
Example 2:
12 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
0 hours -double overtime (time over 12 hours in a 24 hour period)
Example 3:
23 hours- total
8 hours - regular (time less than or = to 8 hours)
4 hours - overtime (time greater than 8 hours but less than 12 hours)
11 hours -double overtime (time over 12 hours in a 24 hour period)
Hope this helps![]()
Bookmarks