The Mathematics of Time Tracking: Clock Time vs. Decimal Hours
In standard everyday life, time is tracked using sexagesimal notation (base-60), where each hour contains 60 minutes and each minute contains 60 seconds. However, automated accounting platforms, enterprise resource planning (ERP) software, and modern payroll processors require centesimal notation (base-100 decimal format) to multiply hours worked by monetary hourly wage rates.
Multiplying $20.00 per hour by a time card showing “8 hours and 30 minutes” cannot be performed by entering 8.30 into an accounting calculator. Because 30 minutes is exactly half of an hour, 8 hours and 30 minutes equals 8.50 decimal hours (8.50 × $20.00 = $170.00). Entering 8.30 would produce $166.00, erroneously underpaying the employee by $4.00.
Full 60-Minute to Decimal Hours Conversion Table
Use this reference table to convert any number of minutes directly into its two-decimal payroll equivalent:
| Min | Dec | Min | Dec | Min | Dec | Min | Dec |
|---|---|---|---|---|---|---|---|
| 1m | 0.02 | 16m | 0.27 | 31m | 0.52 | 46m | 0.77 |
| 2m | 0.03 | 17m | 0.28 | 32m | 0.53 | 47m | 0.78 |
| 3m | 0.05 | 18m | 0.30 | 33m | 0.55 | 48m | 0.80 |
| 4m | 0.07 | 19m | 0.32 | 34m | 0.57 | 49m | 0.82 |
| 5m | 0.08 | 20m | 0.33 | 35m | 0.58 | 50m | 0.83 |
| 6m | 0.10 | 21m | 0.35 | 36m | 0.60 | 51m | 0.85 |
| 7m | 0.12 | 22m | 0.37 | 37m | 0.62 | 52m | 0.87 |
| 8m | 0.13 | 23m | 0.38 | 38m | 0.63 | 53m | 0.88 |
| 9m | 0.15 | 24m | 0.40 | 39m | 0.65 | 54m | 0.90 |
| 10m | 0.17 | 25m | 0.42 | 40m | 0.67 | 55m | 0.92 |
| 11m | 0.18 | 26m | 0.43 | 41m | 0.68 | 56m | 0.93 |
| 12m | 0.20 | 27m | 0.45 | 42m | 0.70 | 57m | 0.95 |
| 13m | 0.22 | 28m | 0.47 | 43m | 0.72 | 58m | 0.97 |
| 14m | 0.23 | 29m | 0.48 | 44m | 0.73 | 59m | 0.98 |
| 15m | 0.25 | 30m | 0.50 | 45m | 0.75 | 60m | 1.00 |
The FLSA 7-Minute Rounding Rule (29 CFR § 785.48(b))
In high-volume hourly workplaces, employees frequently punch in or out a few minutes before or after their designated shift times. Under Section 785.48(b) of the Code of Federal Regulations, the U.S. Department of Labor recognizes the practice of rounding time clock punches to the nearest quarter of an hour (15 minutes).
This standard is commonly known as the 7-minute rule:
- 1 to 7 minutes: The clock time is rounded down to the previous 15-minute increment. For example, a punch at 8:07 AM rounds down to 8:00 AM.
- 8 to 14 minutes: The clock time is rounded up to the subsequent 15-minute increment. For example, a punch at 8:08 AM rounds up to 8:15 AM.
- Neutrality Requirement: Federal courts have repeatedly held that time-rounding policies must be neutral both facially and as applied. If an employer rounds punch-ins up (favoring the company) but does not round punch-outs up (favoring the worker), the practice violates the FLSA and exposes the employer to back-wage liability.
Calculating Night Shifts Crossing Midnight
Shifts operating across midnight represent a common pitfall in amateur spreadsheets. Because the clock resets from 23:59 to 00:00, simple subtraction (End Time - Start Time) results in negative values. To accurately compute an overnight shift: