Calcupedia

Hours to Decimal Calculator

Date & Time

Convert hours, minutes, and seconds into decimal hours instantly. Free tool for payroll and timesheets, plus a full minutes-to-decimal conversion chart.

Ad · Billboard
0100,000
059
059

Decimal Hours

1.5000

The time expressed as a decimal number of hours.

Decimal Minutes

90.0000

The time expressed as a decimal number of minutes.

Decimal Seconds

5,400

The time expressed as a whole number of seconds.

Share result
Reload calculator
Clear inputs

Found this calculator useful?

From Scratch To $10K/Month In 60 Days

This is a proven money making system that takes students by the hand to make at least $10,000 per month, every month. Students get 12 weeks of guided coaching in addition to the "MPS Super Funnel" and tools.

We value your privacy and promise not to sell or misuse your information. Here's our privacy policy.

Calculator Stats

Odeh Ahwal

Creators

Odeh Ahwal
Reviewed and verifiedThis calculator was reviewed and verified by the Calcupedia due diligence team.

0people find this calculator helpful

Views

Helpful

Saved

Embeds

Like
Share
Embed this calculator
Cite
Save
Ad · 300×250

This calculator converts a time written as hours, minutes, and seconds into a single decimal number, the format most payroll systems, invoicing tools, and spreadsheets expect instead of a clock-style duration. Type in any combination of hours, minutes, and seconds and it instantly shows the equivalent in decimal hours, decimal minutes, and decimal seconds.

Decimal hours matter most for payroll. A shift of 7 hours and 45 minutes is not simply 7.45 on a paycheck, since minutes do not divide into 100 the way dollars and cents do. It is actually 7.75 decimal hours, because 45 minutes is three quarters of an hour. Getting this wrong, even slightly, adds up across a pay period and can throw off gross pay calculations.

Below the calculator you will find a full minutes-to-decimal conversion chart covering every value from 1 to 60 minutes, a step-by-step breakdown of the math, and notes on doing the same conversion in Excel or Google Sheets. If you already have a decimal number and need to go the other way, back into hours and minutes, use the Decimal to Time Converter instead.

Ad · 300×250

How to Convert Hours and Minutes to Decimal Time

Converting to decimal time comes down to expressing minutes and seconds as a fraction of an hour, then adding that fraction to the whole hours. Since one hour equals 60 minutes, divide the minute count by 60. Since one hour equals 3,600 seconds, divide the second count by 3,600.

For example, take 2 hours, 45 minutes, and 45 seconds. Dividing 45 minutes by 60 gives 0.75, and dividing 45 seconds by 3,600 gives 0.0125. Adding those to the 2 whole hours gives 2 + 0.75 + 0.0125, which equals 2.7625 decimal hours. The same time can be expressed as a decimal number of minutes or seconds too, shown below.

OutputCalculationResult
Decimal Hours2 + 45/60 + 45/36002.7625
Decimal Minutes2*60 + 45 + 45/60165.75
Decimal Seconds2*3600 + 45*60 + 459945

Already have a decimal number and need to see it as hours, minutes, and seconds instead? The Decimal to Time Converter runs this same conversion in reverse.

Minutes to Decimal Hours Conversion Chart

This is the same lookup most payroll and timesheet software uses internally. Find your minute value in any of the three Min columns below, and read the matching decimal value in the Dec column right next to it.

MinDecMinDecMinDec
10.02210.35410.68
20.03220.37420.70
30.05230.38430.72
40.07240.40440.73
50.08250.42450.75
60.10260.43460.77
70.12270.45470.78
80.13280.47480.80
90.15290.48490.82
100.17300.50500.83
110.18310.52510.85
120.20320.53520.87
130.22330.55530.88
140.23340.57540.90
150.25350.58550.92
160.27360.60560.93
170.28370.62570.95
180.30380.63580.97
190.32390.65590.98
200.33400.67601.00

Common Shift Lengths to Decimal Hours

Most payroll systems round worked time to the nearest quarter hour, so this table covers every 15-minute increment from 15 minutes up to a 9-hour shift. It answers searches like "7 hours 15 minutes in decimal" or "8 hours 45 minutes in decimal" directly, without needing to look up the hours and minutes separately.

TimeDecimalTimeDecimalTimeDecimal
0:150.253:153.256:156.25
0:300.503:303.506:306.50
0:450.753:453.756:456.75
1:001.004:004.007:007.00
1:151.254:154.257:157.25
1:301.504:304.507:307.50
1:451.754:454.757:457.75
2:002.005:005.008:008.00
2:152.255:155.258:158.25
2:302.505:305.508:308.50
2:452.755:455.758:458.75
3:003.006:006.009:009.00

Converting Time to Decimal in Excel or Google Sheets

If your time is stored as a real time-formatted cell, like 2:45:45, multiply it by 24 to get decimal hours. For a cell A1 formatted as time, the formula is =A1*24. If the hours, minutes, and seconds are instead stored as separate plain numbers in columns A, B, and C, use =A1+(B1/60)+(C1/3600) to get the same result directly, no time formatting required.

Frequently Asked Questions

How is decimal time calculated?

Decimal Hours = Hours + (Minutes / 60) + (Seconds / 3600). The same time is also shown converted entirely into decimal minutes and whole seconds.

What is 1 hour and 30 minutes in decimal hours?

1 hour and 30 minutes equals 1.5 decimal hours, since 30 minutes is half of an hour (30 divided by 60 equals 0.5), and 1 plus 0.5 equals 1.5.

What is 45 minutes in decimal?

45 minutes equals 0.75 in decimal hours, because 45 divided by 60 equals 0.75. If the 45 minutes is part of a longer duration, such as 3 hours and 45 minutes, add the whole hours to get 3.75 decimal hours.

How do I convert decimal hours back into hours and minutes?

Take the whole number as the hours, then multiply the decimal portion by 60 to get the minutes. For example, 8.75 hours has a whole number part of 8 and a decimal part of 0.75, and 0.75 times 60 equals 45, so 8.75 hours is 8 hours and 45 minutes. The Decimal to Time Converter runs this exact calculation automatically.

How do I use decimal hours to calculate payroll?

Multiply the decimal hours worked by the hourly pay rate to get gross pay. For example, an employee who worked 7 hours and 45 minutes has 7.75 decimal hours; at an hourly rate of 20 dollars, gross pay for that shift is 7.75 times 20, which equals 155 dollars. The Time Card / Payroll Hours Calculator can calculate this directly from clock-in and clock-out times.

Why do payroll and timesheet systems use decimal hours instead of hours and minutes?

Decimal hours are easier to multiply by an hourly rate and easier for spreadsheets and payroll software to sum across a pay period. Hours and minutes use a base-60 system for the minutes portion, which does not multiply or add cleanly the way a single decimal number does.

How do I convert time to decimal in Excel or Google Sheets?

If the time is stored in a real time-formatted cell, multiply it by 24, for example =A1*24. If hours, minutes, and seconds are stored as separate plain numbers, add them directly with =A1+(B1/60)+(C1/3600).

Spot a mistake? Tell us what's wrong.

Don't see what you need?

Request a calculator. The most-requested ones get built first in our monthly batch.

Request a calculator

Want this calculator on your website?

Embed the Hours to Decimal Calculator on any site — no code needed. Customize colors, remove branding, and track usage.

Embed it free →
Embed on any platform — Next.js, React, Vue.js, PHP, Laravel, Shopify, Wix, Webflow, Squarespace, and more