Minutes to Decimal in Excel
The exact formulas that turn clock time into decimal hours in Excel, and the fraction-of-a-day trap behind the wrong answers.
Key takeaways
- Excel stores 7:45 not as “7 hours 45 minutes” but as a fraction of a day: 0.322917.
- That is why the decimal-hours formula is =A1*24 — multiply the day-fraction back into hours.
- Multiplying by 24 on a cell that shows 7.75 in time format gives a wrong time-looking answer; set the result cell format to Number.
- For total minutes use =A1*1440; for hours-and-minutes parts use =HOUR(A1)+MINUTE(A1)/60.
- Shifts that cross midnight need =MOD(B1-A1, 1) before multiplying, or the result comes out negative.
Why ÷60 is not the Excel way
On paper, converting minutes to decimals is one division: 45 ÷ 60 = 0.75, so 7h 45m becomes 7.75. In Excel the same job is a multiplication instead, because Excel stores every time as a fraction of a 24-hour day. The value you see as “7:45” is really 0.322917 — seven hours and forty-five minutes expressed as a share of one full day. Multiply that fraction by 24 and the day-fraction turns back into plain decimal hours:
decimal hours = time cell × 24
So if A1 contains 7:45, then =A1*24 returns 7.75 — the exact number a payroll system expects in the hours column. The division by 60 already happened inside Excel’s time storage; multiplying by 24 undoes the “day” part, and what remains is hours with a decimal fraction.
The formula reference
All six formulas assume the time value sits in cell A1. Copy the one that matches the output you need:
| Formula | Result for 7:45 |
|---|---|
| =A1*24 | |
| =A1*1440 | |
| =A1*86400 | |
| =HOUR(A1)+MINUTE(A1)/60 | |
| =ROUND(A1*24, 2) | |
| =TEXT(A1*24, "0.00") |
Skip the setup — download the ready-made template
A free weekly timesheet in Excel format with every formula on this page already wired in: decimal conversion, lunch deductions, regular/overtime split and gross pay. Edit the yellow cells, read the answers.
⬇ Download weekly timesheet template (.xlsx)What each formula is for
- =A1*24 — decimal hours — the payroll format.
- =A1*1440 — total minutes.
- =A1*86400 — total seconds.
- =HOUR(A1)+MINUTE(A1)/60 — decimal hours built from the parts, no day-fraction reasoning needed.
- =ROUND(A1*24, 2) — two-place rounding, as most timesheets want.
- =TEXT(A1*24, "0.00") — the same value as text, safe to concatenate into labels.
The trap everyone hits: the result looks like a time again
The single most common failure is not the formula — it is the cell format. Excel keeps the result of =A1*24 in the same format as A1, so 7.75 can display as “18:00” (0.322917 of the next day) or “7:45” lookalikes. The math is right; the display is lying. Fix it once: select the result cells, open Format Cells (Ctrl/Cmd + 1), and set the category to Number with two decimals. From then on every =A1*24 reads as plain decimal hours.
The second trap is text that looks like time. If 7:45 was pasted in as text (often from PDFs and web tables), =A1*24 returns a #VALUE! error. Either retype the value, or convert it first with =TIMEVALUE(A1)*24 — TIMEVALUE turns the text back into a true time fraction.
A worked week, from punch times to payroll
Here is the whole chain on a real three-day week. Start and end times go in columns A and B; the shift duration is their difference; the decimal hours multiply that duration by 24; pay multiplies the decimals by an hourly rate.
| Clock in / out (duration formula) | Decimal hours |
|---|---|
| 09:00 – 17:45 (=B2-A2×24) | |
| 08:30 – 17:00 (=B3-A3×24) | |
| 09:15 – 18:45 (=B4-A4×24) |
Totals and the midnight crossing
Add the daily decimals with plain SUM — decimal hours are plain numbers, so =SUM(D2:D4) gives 26.75 for the week above. There is one exception that needs a different formula: a shift that starts before midnight and ends after it (22:30 to 06:30) gives a negative difference, because the end is numerically smaller than the start. Wrap the subtraction in MOD to flip it positive:
=MOD(B2-A2, 1) * 24
MOD returns the duration as a day-fraction between 0 and 1 even across midnight, and the × 24 turns it into the same decimal hours as every other row. For the rounding rules that decide whether 8:07 logs as 8.00 or 8.25, see the time card rounding guide.
Google Sheets: the same formulas
Google Sheets stores time exactly like Excel — a fraction of a day — so every formula on this page works unchanged. =A1*24, =A1*1440, HOUR/MINUTE decomposition and the MOD midnight fix all behave identically; the only difference is the menu path for setting the result format (Format → Number → Number).