Everyday Math

How to Convert Minutes to Decimal Hours for Timesheets

Read in other languages: 한국어

To convert minutes to decimal hours, divide the minutes by 60. So 45 minutes is 45 ÷ 60 = 0.75 hours, and a shift of 7 hours 45 minutes goes on a timesheet as 7.75 hours. To go the other way, multiply the decimal part by 60: 0.75 × 60 = 45 minutes.

Payroll systems, invoicing tools, and spreadsheets use decimal hours because you can multiply them by an hourly rate directly. Clock times can't be used that way. An hour has 60 minutes, not 100, so "7:45" and "7.45" are not the same thing. Many timesheet errors start there.

This guide covers the formula, a chart of common values, worked examples for single shifts and a full week, and the mistakes that cause the most trouble: misreading 1.30, rounding at the wrong step, and shifts that run past midnight.

How to convert minutes to decimal hours: the formula

The rule is short:

Decimal hours = minutes ÷ 60

If the time has hours and minutes, keep the whole hours as they are and convert only the minutes:

Decimal hours = hours + (minutes ÷ 60)

This works because one minute is 1/60 of an hour. Fifteen minutes is 15/60 of an hour, which simplifies to 1/4, or 0.25. You are just writing that fraction as a decimal.

If your time includes seconds, divide them by 3,600 (60 × 60):

Decimal hours = hours + (minutes ÷ 60) + (seconds ÷ 3,600)

For example, 1 hour 12 minutes 36 seconds = 1 + (12 ÷ 60) + (36 ÷ 3,600) = 1 + 0.2 + 0.01 = 1.21 hours. That's useful if you take times from a call log or a tool like the Online Stopwatch, which records lap and split times.

The reverse: decimal hours to minutes

To turn a decimal back into minutes, multiply the decimal part by 60:

Minutes = decimal part × 60

So 0.4 hours is 0.4 × 60 = 24 minutes, and 2.4 hours is 2 hours 24 minutes.

Minutes to decimal hours chart

Here are the values you'll need most often. Where the decimal goes on forever, the table shows the exact repeating value and the usual two-decimal rounding.

Minutes Exact decimal Rounded (2 places)
1 0.01666… 0.02
3 0.05 0.05
5 0.08333… 0.08
6 0.1 0.10
10 0.16666… 0.17
12 0.2 0.20
15 0.25 0.25
18 0.3 0.30
20 0.33333… 0.33
24 0.4 0.40
25 0.41666… 0.42
30 0.5 0.50
35 0.58333… 0.58
40 0.66666… 0.67
45 0.75 0.75
50 0.83333… 0.83
55 0.91666… 0.92
60 1 1.00

Two patterns make the chart easier to remember:

  • Every 6 minutes adds 0.1 hours. That's why 6, 12, 18, 24, and 30 minutes come out as clean tenths. It's also why some billing systems count time in 6-minute units.
  • Every 3 minutes adds 0.05 hours. If the minutes divide evenly by 3, the decimal ends within two places. Any other value (5, 10, 20, 25 minutes and so on) repeats forever and has to be rounded.

Worked examples: hours and minutes to decimal hours

Single shifts

  1. 7 hours 45 minutes: 45 ÷ 60 = 0.75, so the total is 7.75 hours.
  2. 8 hours 20 minutes: 20 ÷ 60 = 0.3333…, so the total is 8.3333…, written as 8.33 hours.
  3. 2 hours 5 minutes: 5 ÷ 60 = 0.0833…, so the total is 2.0833…, written as 2.08 hours.
  4. 50 minutes on its own: 50 ÷ 60 = 0.8333…, written as 0.83 hours.

Decimal hours back to hours and minutes

  1. 0.3 hours: 0.3 × 60 = 18 minutes, not 30. The digit after the decimal point counts tenths of an hour, not minutes.
  2. 7.6 hours: keep the 7, then 0.6 × 60 = 36, so it's 7 hours 36 minutes.
  3. 1.85 hours: keep the 1, then 0.85 × 60 = 51, so it's 1 hour 51 minutes.
  4. 4.33 hours: 0.33 × 60 = 19.8, which is about 4 hours 20 minutes. The small gap comes from rounding 0.3333… down to 0.33 earlier.

The last example shows why it's worth keeping the full decimal for as long as you can. Round once, at the end.

Adding a week of shifts written in hours and minutes

Say your week looks like this:

Day Time worked Exact decimal Kept to 4 places
Monday 7 h 45 min 7.75 7.7500
Tuesday 8 h 20 min 8.3333… 8.3333
Wednesday 6 h 50 min 6.8333… 6.8333
Thursday 8 h 10 min 8.1666… 8.1667
Friday 7 h 35 min 7.5833… 7.5833

You can total it two ways. Both should give the same answer.

Method 1: Add hours and minutes separately, then convert once

  1. Add the whole hours: 7 + 8 + 6 + 8 + 7 = 36 hours.
  2. Add the minutes: 45 + 20 + 50 + 10 + 35 = 160 minutes.
  3. Turn the extra minutes into hours and minutes: 160 ÷ 60 = 2 with 40 left over, so 160 minutes = 2 hours 40 minutes.
  4. Combine: 36 h + 2 h 40 min = 38 hours 40 minutes.
  5. Convert to decimal: 38 + (40 ÷ 60) = 38.6666…, written as 38.67 hours.

This method keeps the numbers whole until the last step, so there's no rounding error to build up.

Method 2: Convert each day, then add

Add the decimals, kept to four places: 7.7500 + 8.3333 + 6.8333 + 8.1667 + 7.5833 = 38.6666, which rounds to 38.67 hours. Same answer.

Four places is precise enough for a timesheet. Each value is off by at most 0.00005 hours, so five of them together can be off by no more than 0.00025 hours, which is under one second. That is why the total matches Method 1 once you round it to two places.

Applying an hourly rate

At an example rate of $20 per hour, the exact pay is 38.6666… × 20 = $773.33. If you multiply the rounded 38.67 instead, you get 38.67 × 20 = $773.40, a 7-cent difference. Employers and payroll software set their own rules on how many decimal places to keep. If the number on your pay stub looks slightly off, check which step they round at.

To avoid typing mistakes, you can enter the whole week as one expression in the free Online Calculator, which handles parentheses: (7*60+45 + 8*60+20 + 6*60+50 + 8*60+10 + 7*60+35) / 60 works out to 2,320 ÷ 60 = 38.666…. The calculator also keeps a history, so if you enter each day separately you can look back at every result.

Common mistakes when converting time for timesheets

Reading 1.30 as one and a half hours

This is one of the most common errors. "1:30" on a clock means 1 hour 30 minutes, which is 1.5 decimal hours. But "1.30" written as a decimal means 1 hour plus 0.30 of an hour, and 0.30 × 60 = 18 minutes. That's 1 hour 18 minutes.

So if someone writes 1.30 on a decimal timesheet when they meant 1:30, they lose 12 minutes. The same mix-up turns 7:45 into 7.45 (7 hours 27 minutes), a loss of 18 minutes. If the decimal part of a timesheet entry is .60 or more, as in 2.75 or 3.90, it's a decimal. If it never goes above .59, someone may be writing clock time with a dot, so ask before you add it up.

Rounding every entry instead of the total

Rounding each line and then adding lets small errors pile up, especially when the shifts look alike. Take five shifts of 7 hours 20 minutes each, on a timesheet that records one decimal place:

  • Rounding each entry first: 7 h 20 min = 7.333…, rounded to 7.3. Then 7.3 × 5 = 36.5 hours.
  • Rounding the total: 7 h 20 min × 5 = 35 h 100 min = 36 h 40 min = 36.666…, rounded to 36.7 hours.

The gap is 0.2 hours, which is 12 minutes of work that disappears from the timesheet. The errors don't cancel out here because every shift was rounded down by the same amount. Keep full precision (or whole minutes) through the addition, and round once at the end.

Some employers round clock-in and clock-out times to a set interval, such as the nearest quarter hour. Whether and how they can do that depends on local labor rules. If rounding affects your pay, check your employer's written policy and your local labor authority.

Shifts that cross midnight

If a shift starts at 10:30 PM and ends at 6:15 AM, subtracting the clock times gives a negative number. There are two reliable fixes:

  1. Add 24 hours when the end looks earlier than the start. In 24-hour time, the shift runs from 22:30 to 06:15. Then 06:15 − 22:30 = −16 h 15 min, and adding 24 h gives 7 hours 45 minutes = 7.75 hours.
  2. Split the shift at midnight. From 22:30 to 24:00 is 1 h 30 min, and from 00:00 to 06:15 is 6 h 15 min. Together that's 7 h 45 min. This also helps when the two dates go on different lines of the timesheet.

On the nights clocks change for daylight saving time, an overnight shift can be an hour longer or shorter than the clock times suggest. Dates and rules differ by country, so check the local calendar for those nights.

Forgetting unpaid breaks

Subtract breaks in minutes before you convert. A 9:00 AM to 5:30 PM day is 8 h 30 min; with a 30-minute unpaid lunch, that leaves 8 h 0 min, or 8.0 hours. Subtracting 0.5 from 8.5 gives the same result. The trouble starts when a 30-minute break gets entered as 0.30, which takes off only 18 minutes.

Converting time to decimal hours in a spreadsheet

Excel and Google Sheets both store a time like 7:45 as a fraction of a 24-hour day. Internally, 7:45 is 7.75 ÷ 24 ≈ 0.3229. So converting is one step:

  1. Put the start and end times in two cells, such as B2 (start) and C2 (end).
  2. Work out the duration in decimal hours with =(C2-B2)*24.
  3. For shifts that might cross midnight, use =MOD(C2-B2,1)*24. MOD adds a full day whenever the result would be negative.
  4. Format the result cell as a plain number, not as a time. Otherwise the spreadsheet may show 7.75 as a strange clock time.
  5. If you add up durations still in time format, use a custom [h]:mm format so that totals over 24 hours don't wrap back to zero.

If you only have a plain minutes count, such as 465 minutes in cell D2, use =D2/60 to get 7.75.

Checklist before you submit a timesheet

  • Convert with minutes ÷ 60, and keep at least four decimal places until the final total.
  • Scan for entries like 1.30 or 7.45 that may be clock times written with a dot.
  • Subtract unpaid breaks in minutes (30 min, not 0.30) before converting.
  • Give overnight shifts a second look: add 24 hours or split them at midnight.
  • Sanity-check the total both ways: 38 h 40 min should read about 38.67, never 38.40.
  • Round once, at the end, to the number of places your employer or payroll system asks for.

Frequently Asked Questions

How many decimal hours is 8 hours and 15 minutes?

8 hours 15 minutes is 8.25 decimal hours, because 15 ÷ 60 = 0.25. The same quarter-hour pattern gives you 8.5 for 8 h 30 min and 8.75 for 8 h 45 min.

How do I turn decimal hours into a total number of minutes?

Multiply the whole decimal value by 60, not just the part after the point. For example, 2.5 hours × 60 = 150 minutes, and 7.75 hours × 60 = 465 minutes. This is handy when a system asks for minutes only.

Should I use two decimal places or one on my timesheet?

Use whatever your employer or payroll system asks for. Two decimal places (hundredths of an hour) come within about a third of a minute of the real time, while one decimal place can be off by up to 3 minutes per entry. Either way, round the final total rather than each line.

How do I convert decimal hours back to hours and minutes in a spreadsheet?

The most reliable way is to divide by 24 with =A1/24 and format the result as time, using [h]:mm so totals over 24 hours display correctly. You can also split it into parts with =INT(A1) for the hours and =ROUND((A1-INT(A1))*60,0) for the minutes. With that second method, watch for values just under a whole hour, such as 7.999, where the minutes round to 60; in that case add 1 to the hours and show 0 minutes.

Why don't payroll systems just use hours and minutes?

Hours and minutes use base 60, so you can't multiply 7:45 by an hourly rate without converting first. Decimal hours work with ordinary arithmetic: 7.75 × the rate gives the pay right away, and totals add up like any other numbers.