Time to Decimal Calculator

14 min read

Convert hours and minutes to decimal hours for timesheets, payroll, and billing. Supports batch conversion of multiple times, a timesheet calculator with start and end times, military (24-hour) time input, and payroll rounding rules including the 7-minute rule.

How to Convert Time to Decimal Hours

Converting time to decimal hours is straightforward once you understand the core principle. An hour contains 60 minutes, so converting minutes to a decimal fraction of an hour means dividing by 60. If you worked 7 hours and 30 minutes, the conversion is 30 / 60 = 0.5, giving you 7.5 decimal hours. If you worked 8 hours and 45 minutes, the conversion is 45 / 60 = 0.75, giving 8.75 decimal hours.

The formula works the same regardless of the number of hours. For 0 hours and 20 minutes, 20 / 60 = 0.33 decimal hours. For 12 hours and 10 minutes, 10 / 60 = 0.17, giving 12.17 decimal hours. The minutes portion always divides by 60, and the result adds to the whole hours.

Going in reverse (decimal to time) requires multiplying the decimal part by 60. For 6.75 hours, take the decimal 0.75 and multiply by 60 to get 45 minutes: the result is 6 hours and 45 minutes (6:45). For 3.33 hours, 0.33 x 60 = 19.8 minutes, which rounds to 20 minutes, giving approximately 3:20.

Why Decimal Time Matters for Payroll

Payroll systems almost universally require decimal hours rather than hours and minutes. When an employee records 7:45 on their timesheet, the payroll system needs 7.75 to multiply by the hourly rate. If the employee earns $25 per hour, the calculation is 7.75 x $25 = $193.75. Trying to do this math with 7 hours and 45 minutes requires an extra conversion step that introduces potential errors.

Decimal hours also simplify totaling weekly time. Adding 8:30 + 7:45 + 8:15 + 9:00 + 7:30 in time format requires carrying over minutes past 60. In decimal format, 8.5 + 7.75 + 8.25 + 9.0 + 7.5 = 41.0 hours. The addition is simpler and less error-prone.

Many time tracking software systems perform the conversion automatically, but employees and managers who verify timesheets manually understand the conversion. Discrepancies between what an employee reports and what payroll processes often come down to conversion errors between time and decimal formats.

Payroll Rounding Rules Explained

The Fair Labor Standards Act (FLSA) permits employers to round employee time to the nearest increment, provided that the rounding averages out over time and does not systematically favor the employer. The most common rounding increment is 15 minutes (quarter hour), which uses the 7-minute rule.

Under the 7-minute rule, clock-in or clock-out times that fall 1 to 7 minutes past a quarter hour round down to that quarter hour. Times 8 to 14 minutes past round up to the next quarter hour. For example, clocking in at 8:07 rounds to 8:00, but clocking in at 8:08 rounds to 8:15. This symmetric rounding is be neutral over time.

Six-minute rounding (one-tenth of an hour) is standard in legal billing and some professional services firms. Every 6 minutes equals 0.1 hours. Attorneys often track time in six-minute increments: 6 minutes = 0.1 hours, 12 minutes = 0.2 hours, 18 minutes = 0.3 hours, and so on. This system creates clean decimal values that are easy to multiply by billing rates.

Five-minute rounding is less common but used by some organizations. Under this system, time rounds to the nearest 5 minutes: 1-2 minutes past round down, 3-4 minutes round up. Some employers use 1-minute rounding, which effectively means recording exact times with no rounding at all.

Military Time and 24-Hour Clock Conversions

Military time eliminates the ambiguity of AM and PM by using a 24-hour clock that runs from 0000 (midnight) to 2359 (one minute before midnight). Converting from 12-hour to 24-hour format is simple: AM hours stay the same (except 12 AM becomes 0000), and PM hours add 12 (1 PM becomes 1300, 2 PM becomes 1400, and so on, except 12 PM stays 1200).

Healthcare, aviation, emergency services, and international businesses all use 24-hour time to prevent miscommunication. A medication order for "8:00" could mean morning or evening. "0800" or "2000" removes all doubt. Time tracking systems in 24-hour format also eliminate the common data entry error of selecting the wrong AM/PM toggle.

When converting military time to decimal hours for calculations, the process is identical to standard time conversion. 1730 (5:30 PM) becomes 17 hours and 30 minutes, and 30/60 = 0.5, so it converts to 17.5 in 24-hour decimal format. For timesheet purposes, you typically subtract the start time from the end time: if you worked from 0800 to 1730, that is 17.5 - 8.0 = 9.5 hours (before subtracting any lunch break).

Using the Timesheet Calculator

The timesheet calculator above lets you enter start and end times for each day (or shift) and automatically calculates the hours worked. Enter your clock-in time, clock-out time, and any unpaid break time in minutes. The calculator subtracts breaks and converts the result to decimal hours.

For shifts that cross midnight, the calculator handles the wraparound automatically. If you start at 10:00 PM (22:00) and end at 6:00 AM (06:00), the calculator recognizes that the end time is the next day and calculates 8 hours correctly.

The total row sums all daily hours into a weekly (or period) total. If you enter an optional hourly rate, it multiplies the total hours by the rate to show gross pay. This is useful for verifying paychecks or estimating project costs.

Common timesheet mistakes include forgetting to subtract lunch breaks, entering PM times in the AM column (which dramatically inflates hours), and double-counting partial hours. The calculator prevents some of these errors by validating inputs and showing per-row results so you can spot outliers immediately.

Batch Time Conversion for Spreadsheets

When you have a long list of times to convert, the batch mode saves significant effort. Paste your times (one per line) from a spreadsheet or text document, and the calculator converts them all simultaneously. This is particularly useful for accountants processing employee timesheets, project managers tallying hours across team members, or anyone reconciling time records.

The batch converter accepts multiple input formats. You can mix formats in the same batch: "7:30" and "7h 30m" and "7 hours 30 minutes" all parse correctly. For decimal-to-time conversion, just enter the decimal values one per line.

The batch output includes a running total at the bottom, which is useful for verifying that total hours match expectations. You can copy the converted values and paste them back into your spreadsheet.

Common Time to Decimal Conversions

Certain time-to-decimal conversions appear so frequently that memorizing them saves time. The quarter-hour values are the most useful: 15 minutes = 0.25, 30 minutes = 0.50, 45 minutes = 0.75. These correspond to one-quarter, one-half, and three-quarters of an hour respectively.

For six-minute (tenth-of-hour) billing, the pattern is: 6 min = 0.1, 12 min = 0.2, 18 min = 0.3, 24 min = 0.4, 30 min = 0.5, 36 min = 0.6, 42 min = 0.7, 48 min = 0.8, 54 min = 0.9, 60 min = 1.0. These are the values attorneys and consultants use for time entries.

Other frequently encountered conversions: 5 minutes = 0.083 (often shown as 0.08), 10 minutes = 0.167 (0.17), 20 minutes = 0.333 (0.33), 25 minutes = 0.417 (0.42), 35 minutes = 0.583 (0.58), 40 minutes = 0.667 (0.67), 50 minutes = 0.833 (0.83), and 55 minutes = 0.917 (0.92).

Time Tracking Best Practices

Accurate time tracking starts with consistent recording habits. Record your time as close to real-time as possible rather than reconstructing it from memory at the end of the day or week. Studies on time perception show that people consistently overestimate or underestimate durations when recalling from memory, with errors of 10 to 20 percent being common.

Use the same time format throughout your records. If your organization uses 24-hour time, record all times in 24-hour format. Switching between 12-hour and 24-hour within the same document creates conversion errors, especially around the noon and midnight boundaries where mistakes are most likely.

Document break times explicitly. Many wage and hour disputes stem from ambiguity about whether breaks were taken and how long they lasted. Recording start time, break start, break end, and end time for each shift provides a clear record that protects both employer and employee.

For project-based billing, record time by task or activity, not just by day. A time entry of "8 hours on Tuesday" is less useful than "3 hours research, 2 hours drafting, 1.5 hours client calls, 1.5 hours administration." Detailed tracking helps with project estimation, client invoicing, and identifying where time is spent productively versus on overhead.

Overtime Calculation with Decimal Hours

Federal overtime rules under the FLSA require employers to pay 1.5 times the regular rate for hours worked beyond 40 in a workweek. Calculating overtime with decimal hours is straightforward. If an employee works 43.5 hours in a week at $20 per hour: regular pay = 40 x $20 = $800, overtime pay = 3.5 x $30 = $105, total = $905.

Some states have daily overtime rules. California requires overtime after 8 hours in a day and double time after 12 hours. With decimal hours, daily totals are easy to compare against thresholds. If an employee works from 7:00 AM to 4:45 PM with a 30-minute unpaid lunch, that is 9.25 hours, meaning 1.25 hours of overtime for that day.

When rounding is applied, overtime calculations should use the rounded values consistently. If the employer rounds to the nearest 15 minutes, the daily totals used for overtime determination should be the rounded totals. The Department of Labor requires that the rounding method be applied consistently and neutrally across all employees.

Frequently Asked Questions