Batch Time to Decimal Converter
Paste a column of times from a timesheet export or spreadsheet and convert them all at once, with a total. Works both ways: time → decimal and decimal → time.
Updated · Formulas per our methodology
Paste a column straight from Excel or Google Sheets. Accepts 7:45, 7:45:30, 7h 45m, 45 min. Up to 2000 lines.
| Input | Decimal | H:MM |
|---|---|---|
| 7:45 | 7.75 | 7:45 |
| 8:15 | 8.25 | 8:15 |
| 6:30:30 | 6.51 | 6:30:30 |
| 4h 20m | 4.33 | 4:20 |
| 9:05 | 9.08 | 9:05 |
| 0:50 | 0.83 | 0:50 |
Frequently asked questions
How do I convert a list of times to decimal hours?
Paste the times one per line (or copy a column from Excel or Google Sheets), and every line is converted instantly with a running total. Click “Copy results” and paste it back next to your original column.
What time formats are accepted?
H:MM (7:45), H:MM:SS (7:45:30), and unit text such as 7h 45m, 45 min or 1 hour 30 minutes. In Decimal → Time mode, enter decimal hours such as 7.75 or 8,25.
Is my data uploaded anywhere?
No. The conversion runs entirely in your browser, so pasted timesheet data never leaves your device.
Can I do this in Excel instead?
Yes: if A1 contains a time value, =A1*24 returns decimal hours. The batch converter is useful when times are stored as text, mixed formats, or come from another system.
Converting a single value? Use the time to decimal calculator. Adding up shifts from start and end times? Use the timesheet calculator.