Quote:
Originally Posted by Colin Legg
In C5
Gave a value of -1.67 in both the 12hr and 8hr shifts
In D5
Code:
=MAX(0,B5-A5+(A5>B5)-1/3)
Gave a value of 0.17 in the 12hr shift, but 0.0 in the 8hr shift
EDIT: This is a solution to the information in post #3. It does not account for differing overtime hours on weekends; it assumes 8 hour shifts. |
Think I've tried that one before. Any other help and ideas are appreciated!
