Timesheet and payroll in Excel, night shifts included

Task. A small café works out hours and pay by hand. Night shifts that cross midnight and overtime get mixed up, and mistakes surface after payday.

Solution. Timesheet and payroll sit in one Excel workbook built on standard formulas with no macros, and the same file was tested in Google Sheets with every total matching. Hours are calculated for you, including night shifts over midnight and unpaid breaks. Overtime is counted per week, with the 40 hour threshold and the 1.5 rate set on a Settings sheet. A row with a problem, such as an unknown employee, a missing time or a shift over 14 hours, turns red and is never paid silently; the Summary shows how many rows need a look.

The totals were checked against an independent calculation, and every employee's pay matched to the cent. Fictional café and staff. First step for you: the timesheet and pay rules set up for your team in a day, from $80.