Timecard input
Enter hours and minutes.
Type whole numbers, or paste 7:25, 7.5, or 7 hr 25 min into Hours.
Formula
(7 x 60 + 25) / 60
Exact shows 4 decimals. Hundredths shows 2. Quarter-hour snaps to 0.25.
Finance
Time to Decimal Calculator
Use this browser converter for payroll, timecards, and Excel.
payrolltimecardexcelonline
Decimal output
Exact decimal hours
7.4167
7 hours 25 minutes = 445 minutes = 7.4167 decimal hours.
Hundredths
7.42
Quarter-hour
7.50
Minutes total
445
Status
Exact shows 4 decimals. Hundredths shows 2. Quarter-hour snaps to 0.25.
Need a change for Time to Decimal Calculator?
About this calculator
Method, formulas, and limits.What this does
Converts hours and minutes (HH:MM) into decimal hours in three formats: exact decimal hours, hundredths (rounded to two decimals), and quarter-hour rounding. It works entirely in the browser with no server calls.
Who it is for
Payroll processors, freelancers tracking billable hours, managers approving timecards, and anyone who needs to convert time values for spreadsheet calculations or payroll systems.
How it works
Enter the hours and minutes separately or type a time string like 7:25 into the hours field. The calculator immediately shows the exact decimal value (hours + minutes/60), the hundredths value rounded to two decimal places for payroll, and the quarter-hour rounded value for timecards that round to the nearest 15 minutes.
Limitations
Performs time-to-decimal conversion only and does not calculate wages, overtime, or payroll taxes. It does not handle seconds or fractional minutes beyond whole-minute inputs.
Key calculations
- Exact Decimal Hours
- The precise decimal equivalent of HH:MM. decimalHours = hours + minutes / 60
- Hundredths Rounding
- The decimal value rounded to two decimal places, suitable for most payroll systems. hundredths = ROUND(decimalHours, 2)
- Quarter-Hour Rounding
- The decimal value rounded to the nearest 0.25 (15 minutes), used for timecards that round to the quarter-hour. quarterHour = ROUND(decimalHours / 0.25) × 0.25
- Reverse Conversion
- Convert decimal hours back to HH:MM. hours = floor(decimal), minutes = ROUND((decimal - hours) × 60)
Reference ranges
- Common Time Conversions
- 15 min = 0.25 hr. 30 min = 0.50 hr. 45 min = 0.75 hr. 1 hour 15 min = 1.25 hr. 7 hours 36 min = 7.60 hr.
- Payroll Rounding Rules
- Most payroll systems use either hundredths (two decimal places) or quarter-hour (0.25 increments). Some systems round to the nearest 6 minutes (0.10 hr).
- Standard Workday
- 8 hours = 8.00 decimal. 8.5 hours = 8.50 decimal. A 40-hour workweek is 40.00 decimal hours.
- Excel Time Conversion
- Excel stores time as a fraction of a day. Multiply by 24 to convert to decimal hours: =A1*24. For rounding: =MROUND(A1*24, 0.25) for quarter-hours.
How to use it
- 1.Enter timeType hours and minutes separately, or paste a time like 7:25 directly into the Hours field. The fields update in real time.
- 2.Read the exact valueThe exact decimal hours value shows the precise HH:MM conversion. For example, 7 hours 30 minutes = 7.5000 hours.
- 3.Use payroll roundingUse the hundredths value (rounded to 2 decimals) for payroll systems that expect time in decimal format with two digits after the decimal.
- 4.Use quarter-hour for timecardsUse the quarter-hour value when your timecard system rounds to the nearest 15-minute increment. For example, 7:28 rounds to 7.50 (7:30).
- 5.Apply in ExcelUse the decimal value in Excel formulas. To convert a time cell A1 to decimal, multiply by 24: =A1*24. Round with =ROUND(A1*24, 2).
- 6.Convert back if neededIf your spreadsheet shows decimal hours and you need HH:MM, the reverse: hours = INT(decimal), minutes = ROUND((decimal - INT(decimal)) × 60, 0).
A decimal hour writes time in base-10 instead of the traditional hours-and-minutes (HH:MM) format. For example, 1 hour 30 minutes becomes 1.5000 hours, and 7 hours 45 minutes becomes 7.7500 hours. This format is widely used in payroll systems, time tracking software, and spreadsheet calculations because it allows straightforward arithmetic.
Yes. It is built specifically for payroll, timecard, and timesheet conversion. It shows three formats at once: exact decimal hours (most precise), hundredths (rounded to 2 decimal places, used by most payroll systems), and quarter-hour rounding (used by timecards that round to the nearest 15 minutes).
Both. It converts HH:MM into decimal hours in your browser instantly with no server calls, and it displays three useful formats—exact, hundredths, and quarter-hour—so you can use the value that matches your payroll or timecard system without doing the math yourself.
Excel stores time as a fraction of a day, so to convert a time cell (A1) to decimal hours, multiply by 24 with the formula =A1*24. For payroll rounding, use =ROUND(A1*24, 2) for hundredths or =MROUND(A1*24, 0.25) for quarter-hour rounding. The calculator gives you these values directly for reference.
Hundredths rounding rounds the decimal hours to two decimal places (e.g., 7:28 = 7.47 hours), which is the most common format for payroll systems. Quarter-hour rounding rounds to the nearest 0.25 increment (e.g., 7:28 rounds to 7.50 because 28 minutes is closest to 30). Some time tracking systems use quarter-hour, others use hundredths, and some use 6-minute (0.10) increments.
No. The calculator works with whole minutes only. Seconds and fractional minutes (e.g., 7:28:30 or 7:28.5) are not supported. For most payroll and timecard use cases, rounding to the nearest whole minute is standard practice, so this limitation rarely matters in practice.
To convert decimal hours back to HH:MM, take the whole number as the hours, then multiply the fractional part by 60 to get the minutes. For example, 7.75 hours: 7 hours + (0.75 × 60) = 7:45. In Excel, use =INT(A1) for hours and =ROUND(MOD(A1,1)*60, 0) for minutes.
Related calculators
Quick jumps
Illinois Paycheck Calculator
Use decimal hours in a payroll estimate.
Ohio Paycheck Calculator
Compare timecard hours with take-home pay.
401k Calculator
Project 401k growth with employer match, then simulate retirement withdrawals over time.
Coast FIRE Calculator
See when your portfolio can coast to retirement on its own.