Reply to Message

We can come up with a formula for you -- but I need all the details. Now, the overtime in this particular sheet is greater than 8 hours worked in any given day, but it only considers actual hours worked. You want anything over 8 hours in a day that also considers sick time and vacation? That one confuses me a bit -- if an employee took 4 hours of sick time and then worked 5 hours, they'd be an overage of 1 hour. Why wouldn't the employee just claim 3 sick hours instead?