Time to Decimal Conversion Chart for Payroll and Timesheets
Payroll systems work in decimal hours, not hours and minutes. When a timesheet shows 7 hours and 45 minutes, payroll needs 7.75. Getting this conversion wrong — even by a few minutes per employee per day — adds up to significant over- or underpayment across a pay period.
This guide gives you the complete conversion chart, the formula, and the rounding rules you need for accurate payroll processing.
- Decimal hours = Hours + (Minutes / 60) — for example, 7 hours 45 minutes = 7.75
- Most payroll systems round to the nearest quarter hour (:00, :15, :30, :45)
- The FLSA permits rounding only if it averages out and does not systematically favor the employer
- Manual time-to-decimal conversion introduces transcription, rounding, and formula errors at every step
- Automatic time tracking eliminates the conversion step entirely by recording hours in decimal format
What is time to decimal conversion?
Time to decimal conversion translates hours-and-minutes format (7:45) into decimal format (7.75) so payroll systems can calculate wages accurately.
The formula is simple:
Decimal hours = Hours + (Minutes / 60)
Example: 7 hours and 45 minutes = 7 + (45 / 60) = 7 + 0.75 = 7.75 decimal hours
Why payroll uses decimal hours
Payroll calculations require multiplication: hours worked x hourly rate = gross pay. Decimal format makes this straightforward.
- 7.75 hours x $20/hour = $155.00
- 7 hours 45 minutes x $20/hour = ... requires a conversion step first
Most payroll software, accounting systems, and spreadsheet formulas expect decimal input. Converting before entry prevents calculation errors.
Complete minutes to decimal hours chart
Use this reference table to convert any minute value to its decimal equivalent. Bookmark this page for quick access.
| Minutes | Decimal | Minutes | Decimal | Minutes | Decimal | ||
|---|---|---|---|---|---|---|---|
| 1 | 0.02 | 21 | 0.35 | 41 | 0.68 | ||
| 2 | 0.03 | 22 | 0.37 | 42 | 0.70 | ||
| 3 | 0.05 | 23 | 0.38 | 43 | 0.72 | ||
| 4 | 0.07 | 24 | 0.40 | 44 | 0.73 | ||
| 5 | 0.08 | 25 | 0.42 | 45 | 0.75 | ||
| 6 | 0.10 | 26 | 0.43 | 46 | 0.77 | ||
| 7 | 0.12 | 27 | 0.45 | 47 | 0.78 | ||
| 8 | 0.13 | 28 | 0.47 | 48 | 0.80 | ||
| 9 | 0.15 | 29 | 0.48 | 49 | 0.82 | ||
| 10 | 0.17 | 30 | 0.50 | 50 | 0.83 | ||
| 11 | 0.18 | 31 | 0.52 | 51 | 0.85 | ||
| 12 | 0.20 | 32 | 0.53 | 52 | 0.87 | ||
| 13 | 0.22 | 33 | 0.55 | 53 | 0.88 | ||
| 14 | 0.23 | 34 | 0.57 | 54 | 0.90 | ||
| 15 | 0.25 | 35 | 0.58 | 55 | 0.92 | ||
| 16 | 0.27 | 36 | 0.60 | 56 | 0.93 | ||
| 17 | 0.28 | 37 | 0.62 | 57 | 0.95 | ||
| 18 | 0.30 | 38 | 0.63 | 58 | 0.97 | ||
| 19 | 0.32 | 39 | 0.65 | 59 | 0.98 | ||
| 20 | 0.33 | 40 | 0.67 | 60 | 1.00 |
Quick reference: common time conversions
Quarter-hour increments
Most payroll systems round to the nearest quarter hour. These are the four values you will use most often:
| Time | Decimal |
|---|---|
| :00 | .00 |
| :15 | .25 |
| :30 | .50 |
| :45 | .75 |
Sixth-of-an-hour (6-minute) increments
Common in legal billing and professional services where time is tracked in tenths of an hour:
| Time | Decimal |
|---|---|
| :00 | .0 |
| :06 | .1 |
| :12 | .2 |
| :18 | .3 |
| :24 | .4 |
| :30 | .5 |
| :36 | .6 |
| :42 | .7 |
| :48 | .8 |
| :54 | .9 |
How to convert time to decimals for payroll
Step 1: Record start and end times
For each work period, note the clock-in and clock-out times. Example: 8:15 AM to 5:00 PM.
Step 2: Calculate total hours and minutes
5:00 PM minus 8:15 AM = 8 hours and 45 minutes. Subtract any unpaid break time. If the employee took a 30-minute unpaid lunch: 8 hours 45 minutes - 30 minutes = 8 hours 15 minutes.
Step 3: Convert minutes to decimal
Divide the minutes by 60: 15 / 60 = 0.25. Total decimal hours: 8.25.
Step 4: Multiply by hourly rate
8.25 hours x $22/hour = $181.50 gross pay for the shift.
Worked example
| Employee | Clock In | Clock Out | Lunch | Total Time | Decimal | Rate | Pay |
|---|---|---|---|---|---|---|---|
| Smith | 7:45 AM | 4:30 PM | 0:30 | 8h 15m | 8.25 | $18 | $148.50 |
| Jones | 8:00 AM | 5:15 PM | 1:00 | 8h 15m | 8.25 | $22 | $181.50 |
| Patel | 9:10 AM | 6:00 PM | 0:30 | 8h 20m | 8.33 | $25 | $208.25 |
Common rounding rules for payroll
The FLSA 7-minute rounding rule
The FLSA permits employers to round employee time to the nearest quarter hour (15 minutes), provided the rounding averages out over time and does not systematically benefit the employer.
The practical application:
- 1-7 minutes round down (e.g., 8:07 rounds to 8:00)
- 8-14 minutes round up (e.g., 8:08 rounds to 8:15)
This is known as the "7-minute rule" because 7 minutes is the dividing line.
Quarter-hour vs. tenth-of-an-hour rounding
| Rounding method | Increments | Used by | Precision |
|---|---|---|---|
| Quarter-hour (15 min) | .00, .25, .50, .75 | Most employers | Lower |
| Tenth-of-an-hour (6 min) | .0 through .9 | Legal, consulting, agencies | Higher |
| Actual minutes | All values | Automatic time tracking | Highest |
Why rounding creates compliance risk
While FLSA permits rounding, it also requires that rounding be neutral over time. If your rounding practices consistently round down (in the employer's favor), employees can bring wage claims. Courts have found employers liable for rounding practices that systematically shortchange employees, even by a few minutes per shift.
The safest approach is to track actual minutes and convert to decimal — no rounding required. Automatic time tracking does this by default.
Important
FLSA-permitted rounding must be neutral over time. If your rounding practices consistently round down in the employer's favor — even by a few minutes per shift — employees can bring wage claims. Courts have found employers liable for systematic rounding bias.
Skip the Manual Conversion Entirely
HiveDesk records exact start and end times and generates payroll-ready timesheets in decimal format automatically. No rounding, no conversion errors, no compliance risk.
Why manual time conversion creates payroll errors
Manual time-to-decimal conversion introduces errors at every step:
- Transcription mistakes. Copying times from a paper timesheet to a spreadsheet is error-prone. Transposing 7:45 as 7:54 changes the decimal from 7.75 to 7.90 — a 9-minute error per entry.
- Inconsistent rounding. Different managers round differently. One rounds 8:07 down to 8:00; another rounds it up to 8:15. These inconsistencies accumulate across a pay period.
- Formula errors. Spreadsheet formulas can break when copied across rows, reformatted, or edited by multiple people.
- Volume. A 50-person team with daily clock-in and clock-out generates 500+ conversion calculations per week. Even a 1% error rate means 5 incorrect entries every week.
The cost of these errors runs in both directions. Overpayment costs the employer money. Underpayment creates legal liability. Neither is acceptable.
Key Takeaway
A 50-person team generates 500+ conversion calculations per week. Even a 1% error rate means 5 incorrect entries every week — errors that compound into significant over- or underpayment across a pay period.
How automatic time tracking eliminates manual conversion
When employees use automatic time tracking software, the system records exact start and end times to the minute. Timesheet reports are generated in decimal hours automatically — no manual conversion step required.
HiveDesk tracks time via desktop, mobile, and browser apps, then generates payroll-ready timesheets in decimal format. The manual conversion step simply disappears, along with the errors it introduces.
At $5/user/month with all features included, the cost of automatic tracking is trivial compared to the payroll errors it prevents.
Frequently asked questions
What is 7 hours and 45 minutes in decimal?
7.75. Divide 45 minutes by 60 to get 0.75, then add to the 7 hours.
How do I convert 20 minutes to decimal hours?
Divide 20 by 60 = 0.33 (rounded to two decimal places).
What decimal is 30 minutes?
0.50. This is the most common conversion — half an hour equals half a decimal hour.
Why do payroll systems use decimal hours?
Decimal hours simplify wage calculations. Multiplying decimal hours by an hourly rate gives gross pay directly ($18/hour x 8.25 hours = $148.50). Hours-and-minutes format requires an extra conversion step that introduces error opportunities.
What is the FLSA rounding rule?
The FLSA permits employers to round employee time to the nearest quarter hour (15 minutes) using the 7-minute rule: 1-7 minutes round down, 8-14 minutes round up. Rounding must be neutral over time and cannot systematically benefit the employer. Many employers avoid rounding entirely by tracking actual minutes with time tracking software.
