Work Hours to Decimal Time Converter

Your timesheet arrives as pasted text — “7h 30m” on one line, “8:15” on the next, “7.5” after that — and payroll needs decimal hours. Converting row by row by hand wastes time, and rounding each row instead of the total quietly adds small errors. This work hours to decimal time converter fixes both: paste the whole sheet, deduct breaks once per row, and get decimal hours per row plus one total that is rounded at total level only.

How to use this work hours to decimal time converter in 3 steps

Step 1 — paste your timesheet. Copy your entries from email, chat or a spreadsheet and paste them into the box, one per line. Mixed formats are fine: “7h 30m”, “7:30”, “7.5” and “7h30” are all recognised.

Step 2 — enter your break. Type the break minutes per day, for example 30. It is deducted once per row, exactly as entered, so every day’s net hours come out right.

Step 3 — calculate and copy. Press Calculate totals to see each row parsed with its decimal hours, plus the total rounded at total level only. Copy the result for payroll or print it for your records.

Worked example: mixed timesheet to decimal hours

Here is a five-day sheet pasted in four different formats, with a 30-minute break per day. Press Load example in the tool to run these exact numbers yourself.

The per-row decimals are shown to 2 decimals for display only. The total is calculated from the unrounded values and rounded once, at total level.

Change the break to 0 and the total becomes 37.50. Change it to 60 and the total becomes 32.50. The break flows straight through to the total, which is exactly what payroll expects.

Common mistakes when converting work hours to decimal time

Rounding each row. Rounding every day to 2 decimals and then adding them up introduces small errors that grow across a week or a month. This tool keeps every row unrounded and rounds the total once.

Forgetting breaks. Many people convert gross hours and subtract breaks at the end, or forget them entirely. Enter the break once and the tool deducts it from every row automatically.

Typing hours as decimals wrong. 7h 45m is 7.75 decimal hours, not 7.45. The reverse converter turns any decimal back into hours and minutes so you can double-check payroll figures.

Planning your week around those hours? Try the Backlog Catch-Up Planner by Day to see if your backlog fits before the deadline, or the Exam Section Time Planner by Marks to split exam time without running out.

Work hours to decimal time converter FAQs

What formats can I paste into the timesheet box?

You can paste entries like “7h 30m”, “7:30”, “7.5”, “7h30” and “45m”, one per line, and even mix them in the same sheet. Anything the tool cannot recognise is flagged in the results table so it never silently corrupts your total.

Is the break deducted per row or once for the whole sheet?

The break is deducted once per row, which means once per day when each line is a day. Enter 30 and every row loses 30 minutes before the total is calculated, which matches how most payroll breaks work.

Why is only the total rounded?

Rounding each row to 2 decimals before adding creates small errors that accumulate across many rows. Keeping every row unrounded and rounding the final total once gives the most accurate decimal hours figure for payroll.

How do I convert a single entry like 7h 45m?

Use the single-entry converter below the timesheet tool: enter 7 hours and 45 minutes and press Convert to decimal to get 7.75. It is ideal for one-off conversions without pasting a whole sheet.

How do I convert decimal hours back, for example 7.75?

Use the reverse converter: enter 7.75 and press Convert to hours + minutes to get 7h 45m. This is handy for checking payroll figures that arrive as decimals.