Hi, I have a group of people who work 7 and a half hours per Weekday and 4 and a half hours on a Saturday, for anything else they get overtime.
I have a column recording the day called [Day] using the DAY() expression
I have a column called [Calculated Time] which accumulates the time for the day by subtracting time out from time in TOTALHOURS([Time Out]-[Time In])
How do I determine when there is overtime worked.
Would this require an IF and OR expression?
Solved! Go to Solution.
[Day] = 1 , 0
User | Count |
---|---|
43 | |
30 | |
27 | |
14 | |
14 |