Timesheet Shift Details
📊 Timesheet Breakdown
Accurately recording working hours on daily timesheets ensures employees are paid correctly for all hours worked and employers remain compliant with payroll regulations.
Converting hours and minutes into decimal hours is standard practice across modern payroll systems like Xero, Sage, and QuickBooks.
⚙️ Statutory Rest Break Rules & Decimal Conversion Math
1. Statutory Rest Breaks under Working Time Regulations
Under Regulation 12 of the Working Time Regulations 1998:
- Shifts Over 6 Hours: Workers have the statutory right to at least one uninterrupted 20-minute rest break during the working day.
- Paid vs Unpaid Breaks: Employer contracts dictate whether rest breaks are paid or unpaid. Meal/lunch breaks are almost universally unpaid unless specified otherwise in your employment handbook.
2. Hours & Minutes to Decimal Hours Conversion
Payroll software processes wages by multiplying hourly rates by decimal hours:
- 15 Minutes: 15 / 60 = 0.25 Hours
- 30 Minutes: 30 / 60 = 0.50 Hours
- 45 Minutes: 45 / 60 = 0.75 Hours
- Formula:
Paid Hours = (End Time - Start Time - Unpaid Break) in Decimal
📊 Practical Timesheet Worked Examples
Below are two worked calculation examples illustrating shift hour calculations:
- Total Elapsed Time (08:30 to 17:00): **8 Hours 30 Minutes**
- Unpaid Lunch Break: **30 Minutes (0.50 hours)**
- Net Paid Working Time: 8.50 - 0.50 = **8.00 Hours**
Calculation: 8.00 hours × £15.00/hr = £120.00 gross daily pay.
- Total Elapsed Time (09:00 to 17:15): **8 Hours 15 Minutes (8.25 hours)**
- Unpaid Lunch Break: **45 Minutes (0.75 hours)**
- Net Paid Working Time: 8.25 - 0.75 = **7.50 Hours**
Calculation: 7.50 hours × £16.00/hr = £120.00 gross daily pay.
📑 Common Pitfalls & Timesheet Errors
- Confusing Minutes with Decimals (The .30 vs .50 Error): Entering 7 hours and 30 minutes into payroll as
7.30instead of7.50results in underpaying the employee by 12 minutes (0.20 hours) per shift! - Forgetting Night Shift Midnight Crossovers: Shifts starting in the evening (e.g. 22:00) and ending the following morning (e.g. 06:00) cross midnight. Timesheet software must add 24 hours to the end time to calculate 8 elapsed hours correctly.
- Failing to Track Daily 11-Hour Rest Periods: Workers are entitled to a minimum of 11 consecutive hours of daily rest between ending one work shift and starting the next.
❓ Frequently Asked Questions (FAQ)
Whether short tea breaks (e.g. 10 or 15 minutes) are paid depends entirely on your employer's contract terms. There is no statutory requirement for short tea breaks to be paid, though many employers do pay for short comfort breaks.
Divide the number of minutes by 60. For 45 minutes: 45 ÷ 60 = 0.75. So 7 hours and 45 minutes equals 7.75 decimal hours.
Workers have the statutory right to an uninterrupted 24-hour rest period without work each week, or a 48-hour uninterrupted rest period every fortnight.
If an employee was required to work through their lunch break due to business operational needs, the employer must pay for those working hours so that average pay does not fall below National Minimum Wage.