Time to Decimal Calculator
Convert HH:MM:SS time to decimal hours. Widely used in payroll systems, timesheets, and spreadsheets where time must be stored as a single decimal number.
1.5 hours
Formula
Decimal hours = H + M ÷ 60 + S ÷ 3600
How to Convert Time to Decimal Hours
To convert HH:MM:SS to decimal hours:
Decimal hours = H + M ÷ 60 + S ÷ 3600
Example: 2:30:00 → 2 + 30÷60 + 0÷3600 = 2.5 hours
Example: 1:15:30 → 1 + 15÷60 + 30÷3600 = 1.2583 hours
This format is used in payroll (e.g. 8.5 hours worked) and spreadsheet time arithmetic.
Time to Decimal Hours Reference Table
| HH:MM:SS | Decimal Hours |
|---|---|
| 00:00:30 | 0.008333 |
| 00:01:00 | 0.016667 |
| 00:05:00 | 0.083333 |
| 00:10:00 | 0.166667 |
| 00:15:00 | 0.25 |
| 00:30:00 | 0.5 |
| 01:00:00 | 1 |
| 01:30:00 | 1.5 |
| 02:00:00 | 2 |
| 04:00:00 | 4 |
| 06:00:00 | 6 |
| 08:00:00 | 8 |
| 12:00:00 | 12 |
| 24:00:00 | 24 |