I need to develop a payroll spreadsheet that can capture the following information on a daily basis:
Date
Employee #
Name
Reg Hours
Ot Hours
Holiday Hours
Sick Hours
D.E. Premium
ENG Premium
RTO Hours
NST Hours
ADJ Hours
STO Day (if hours worked on STO day then add 0.25 premium pay)
Also need a summary by any field;
And a report that I could generate that info with at date-range input.
Ultimately would like to be able to integrate this with employee schedule, or be able to input because if they work on a scheduled day off then they get premium pay.
I'm not having any luck with this....any suggestions/help would be greatly appreciated!
Bookmarks