I work in a small fire department, and recently got tasked with updating our payroll spreadsheet to alleviate some of problems we've been having with calculating payroll. I understand basic excel formulas, and I created a form that would could be used to add runs, along with who was present for that run. I'll add an attachment to what I have so far, but basically each run will have it's own number, a date, time, and hours paid for the length of that specific call. I have my rows set up as personnel, and columns as runs. The form has the inputs for the run information, and check boxes for each individual employee, so I want to set it up so whoever is entering the data can check off who was there, and the hours paid will populate in that persons cell for that run. Any advice would be greatly appreciated! Test Master Payroll Macro-Enabled.xlsm
Bookmarks