Payroll Time Conversion Chart Generator
Standard Formula
Generates reference lookup between clock minutes (1 to 60) and payroll decimal hours.
Reference guide converting standard payroll minutes into hundredths of an hour.
How Payroll Time Conversion Chart Generator Works?
The Payroll Time Conversion Chart Generator works by dividing each minute value from 1 to 60 by 60 and rounding to hundredths of an hour. The lookup field returns one value; the chart below lists all 60.
1Enter a minute value
Type any minute from 1 to 60, 35 by default.
2Read the decimal
35 minutes returns 0.58 hours.
3Check the anchors
The tool lists 15 min = 0.25, 30 min = 0.50, 45 min = 0.75 and 60 min = 1.00.
4Print the chart
Use the full 60-row chart on this page as a desk reference or timeclock poster.
Payroll Time Conversion Chart Generator Formula
The Payroll Time Conversion Chart Generator formula is Decimal Hours = Minutes ÷ 60, rounded to 2 decimal places.
Hundredths of an hour
Decimal = Round(Minutes ÷ 60, 2)
Full time entry
Entry = Hours + Decimal
- Minutes
- Minutes past the hour, 1–60.
- Decimal
- Hundredths of an hour used on timesheets.
- Entry
- Complete decimal time for payroll.
Worked example: 6 hours 35 minutes
35 minutes = 0.58. Entry = 6 + 0.58 = 6.58 hours.
Payroll Time Conversion Chart Generator Conversion Table
The Payroll Time Conversion Chart Generator conversion table lists all 60 minutes with the matching hundredths-of-an-hour value used by payroll.
| Minutes | Decimal Hours | Minutes | Decimal Hours |
|---|---|---|---|
| 1 min | 0.02 | 31 min | 0.52 |
| 2 min | 0.03 | 32 min | 0.53 |
| 3 min | 0.05 | 33 min | 0.55 |
| 4 min | 0.07 | 34 min | 0.57 |
| 5 min | 0.08 | 35 min | 0.58 |
| 6 min | 0.10 | 36 min | 0.60 |
| 7 min | 0.12 | 37 min | 0.62 |
| 8 min | 0.13 | 38 min | 0.63 |
| 9 min | 0.15 | 39 min | 0.65 |
| 10 min | 0.17 | 40 min | 0.67 |
| 11 min | 0.18 | 41 min | 0.68 |
| 12 min | 0.20 | 42 min | 0.70 |
| 13 min | 0.22 | 43 min | 0.72 |
| 14 min | 0.23 | 44 min | 0.73 |
| 15 min | 0.25 | 45 min | 0.75 |
| 16 min | 0.27 | 46 min | 0.77 |
| 17 min | 0.28 | 47 min | 0.78 |
| 18 min | 0.30 | 48 min | 0.80 |
| 19 min | 0.32 | 49 min | 0.82 |
| 20 min | 0.33 | 50 min | 0.83 |
| 21 min | 0.35 | 51 min | 0.85 |
| 22 min | 0.37 | 52 min | 0.87 |
| 23 min | 0.38 | 53 min | 0.88 |
| 24 min | 0.40 | 54 min | 0.90 |
| 25 min | 0.42 | 55 min | 0.92 |
| 26 min | 0.43 | 56 min | 0.93 |
| 27 min | 0.45 | 57 min | 0.95 |
| 28 min | 0.47 | 58 min | 0.97 |
| 29 min | 0.48 | 59 min | 0.98 |
| 30 min | 0.50 | 60 min | 1.00 |
Values are rounded to 2 decimals. 1 minute = 0.0167 hours before rounding.
What is Payroll Time Conversion Chart Generator?
A Payroll Time Conversion Chart Generator is a reference tool that lists the decimal-hour value of every minute in an hour.
Payroll clerks, supervisors and workers who fill out paper timesheets use the chart to convert minutes without a calculator. The chart removes the most common entry error: writing 8:20 as 8.20 instead of 8.33.
Rounding to 2 decimals introduces a gap of up to 18 seconds per entry. Payroll systems that store 4 decimals avoid that gap.
What are the uses of Payroll Time Conversion Chart Generator?
There are 4 main uses of the Payroll Time Conversion Chart Generator.
Timeclock posters
Employers post the chart beside the punch clock.
Paper timesheets
Field crews convert minutes on job sites without a phone.
Payroll training
New payroll clerks learn decimal entry.
Quick lookups
Workers find the decimal for any single minute value.