Does anyone have a quick formula to calculate employees total hours worked by date (sum of regular, overtime and double-time)?
Any help is appreciated!
Set up a separate fomula for each pay ID and then total these together. For regular hours, the formula would be
IF(pay ID ="1", Units)
The record used is PR-Time. You would substitute the "1" with your specificic pay ID.
Once you have the three formulas set up, you can just create another formula that adds those three together.
*Community Hub is the new name for Sage City