All four crews, week of the 10th. Payroll sheet the usual way, and keep Rialto separate from Fontana. Fair warning, a few of them are a mess.
31 photos 4 crews- One row per person per day, your existing columns
- Job number off the ticket header, so Rialto and Fontana stay split
- Overtime past 40 in its own column, same as February
Flag them. Yes on Saturday.
Done. 31 tickets in, 2 flagged.
Payroll_week_of_Mar_10.xlsx 38 KB- 7:44 Read 31 handwritten tickets, 4 crews
- 7:47 Pulled name, job number, hours, materials
- 7:52 Two illegible. Asked instead of guessing
- 8:09 Totaled hours by person and by job
- 8:14 Matched your payroll columns. Filed in Payroll / March