ClockedSum

Time to decimal

Hours and minutes as decimal hours for payroll, a whole week at once.

Example values, change them. The answer updates as you type.

Round each entry
7.75
8.17
6.83
8.00
4.50
35.25 h Full breakdown below
Total in decimal hours
35.25 h
5 entries, 35:15 in hours and minutes.
35:15 Hours and minutes
5 Entries
Exact Rounding

Checked by JunaydMethod and sources

Each day in decimal hours

  • Monday 7.75 h
  • Tuesday 8.17 h
  • Wednesday 6.83 h
  • Thursday 8.00 h
  • Friday 4.50 h

Decimal hours to 2 places. A minute is 0.0167 of an hour, so 1 minute shows as 0.02.

Your 5 entries come to 35.25 decimal hours.

How do I convert time to decimal?

To convert time to decimal, divide the minutes by sixty and add them to the hours. 45 minutes is 0.75 of an hour, so 7 hours 45 minutes is 7.75. Some employers round each entry to the nearest tenth or quarter of an hour.

How we worked it out

  1. Monday: 7 h 45 min = 7 + 45 ÷ 60 = 7.75 h
  2. Tuesday: 8 h 10 min = 8 + 10 ÷ 60 = 8.1666… h → 8.17 h
  3. Wednesday: 6 h 50 min = 6 + 50 ÷ 60 = 6.8333… h → 6.83 h
  4. Thursday: 8 h 0 min = 8 + 0 ÷ 60 = 8.00 h
  5. Friday: 4 h 30 min = 4 + 30 ÷ 60 = 4.50 h
  6. Total: 35:15 = 2,115 min ÷ 60 = 35.25 h

Minutes to decimal hours

Each minute is one sixtieth of an hour, so the decimal for most minutes runs on for ever. The table rounds each one to two places.

MinutesDecimal hoursMinutesDecimal hours
10.02310.52
20.03320.53
30.05330.55
40.07340.57
50.08350.58
60.10360.60
70.12370.62
80.13380.63
90.15390.65
100.17400.67
110.18410.68
120.20420.70
130.22430.72
140.23440.73
150.25450.75
160.27460.77
170.28470.78
180.30480.80
190.32490.82
200.33500.83
210.35510.85
220.37520.87
230.38530.88
240.40540.90
250.42550.92
260.43560.93
270.45570.95
280.47580.97
290.48590.98
300.50––

Each decimal is the minutes divided by 60, rounded to two places.

Rounding on a timesheet

Federal rules let employers round clock times to the nearest 5 minutes, tenth of an hour or quarter of an hour. The rounding must average out, so you're paid for all the time you actually work.

Worked examples

A week of five entries, exact

Round each entry ExactMonday hours 7Monday minutes 45 minTuesday hours 8Tuesday minutes 10 minWednesday hours 6Wednesday minutes 50 minThursday hours 8Thursday minutes 0 minFriday hours 4Friday minutes 30 min

Your 5 entries come to 35.25 decimal hours.

Total in decimal hours
35.25
Total minutes
2,115
Entries
5
Monday in decimal hours
7.75

The same week to the tenth of an hour

Round each entry TenthMonday hours 7Monday minutes 45 minTuesday hours 8Tuesday minutes 10 minWednesday hours 6Wednesday minutes 50 minThursday hours 8Thursday minutes 0 minFriday hours 4Friday minutes 30 min

Your 5 entries come to 35.30 decimal hours.

Total in decimal hours
35.30
Total minutes
2,115
Entries
5
Monday in decimal hours
7.80

Common questions

Is .75 the same as 45 minutes?

Yes: 45 minutes divided by the minutes in an hour is 0.75, so 0.75 hours and 45 minutes are the same length of time.

How much payroll time is 15 minutes?

It's 0.25 of an hour, a quarter hour. A quarter hour is one of the steps federal rules let employers round clock times to.

How do you write 2 hours and 30 minutes in decimal?

It's 2.5 hours: 30 minutes is half an hour.

How do I convert time to decimal in Excel?

Multiply the time cell by the hours in a day and format the result as a number: =A1*24 turns 7:45 into 7.75.

How do I convert decimal hours to hours and minutes?

Keep the whole hours, then multiply the decimal part by the minutes in an hour. So 7.75 hours is 7 hours and 45 minutes.

Have clock-in and clock-out times?

Add up a week of start and end times, with breaks and overtime.

Open the time card

More pay and hours calculators

Method and sources

Each calculator applies the published federal or state rule to the hours and pay you enter and rounds each amount to the nearest cent. Every step is shown, and every rule links to its official page with the date we checked it. Not legal or tax advice; the pages never decide whether you're exempt. Spot something wrong? Tell us and we will fix it and note the change.

  • Decimal hours are shown to two places; half a hundredth rounds up.
  • Rounding to the tenth or quarter hour applies to each entry, then the entries are added.