Convert hours and minutes into decimal hours for payroll and
timesheets — or convert decimal hours back into hours and minutes. Also
calculate total hours worked from a clock-in and clock-out time.
Ad slot — above tool
Decimal hours
—
Enter hours and minutes
For example, 7.75 means 7 hours and 45 minutes
Hours & minutes
—
Enter a decimal value
Total worked
—
Enter clock in and clock out
Ad slot — below tool
How to convert time to decimal
Payroll systems and spreadsheets work with decimal hours, not the
hours-and-minutes format on a clock. To convert, keep the hours as they are
and divide the minutes by 60:
Decimal hours = Hours + (Minutes ÷ 60)
Example: 7 hours 45 minutes → 45 ÷ 60 = 0.75, so the
decimal value is 7.75 hours. A 30-minute lunch is 30 ÷ 60 =
0.5 hours.
The reason you divide by 60 is that an hour has 60 minutes — each minute is
one-sixtieth of an hour. This is why 15 minutes is 0.25 and 20 minutes is
0.333.
How to convert decimal back to time
To go the other way, keep the whole number as hours and multiply the
decimal part by 60 to get minutes:
Easy multiplication — gross pay is simply decimal hours × hourly
rate. You can't multiply "7:45" by a pay rate directly.
Spreadsheet friendly — Excel and payroll software add and total
decimal numbers cleanly.
Fewer errors — mixing the 60-minute clock with base-10 math is a
common source of timesheet mistakes.
Frequently asked questions
How do you convert time to decimal?
Divide the minutes by 60 and add the result to the hours.
For 7 hours 45 minutes: 45 ÷ 60 = 0.75, so the decimal time is 7.75.
What is 45 minutes as a decimal?
45 minutes is 0.75 hours, because 45 ÷ 60 = 0.75.
What is 15 minutes in decimal form?
15 minutes is 0.25 hours (15 ÷ 60 = 0.25).
How do I convert decimal hours back to minutes?
Multiply the decimal portion by 60. In 6.5 hours, the
0.5 becomes 0.5 × 60 = 30 minutes, giving 6 hours 30 minutes.
How do I calculate hours worked from a timesheet?
Subtract the clock-in time from the clock-out time, then
subtract any unpaid break. The "Hours worked" tab does this and shows the
result in decimal hours.
