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?
LinkedIn
Twitter
