Time / Guides

Decimal hours vs hours and minutes: read a timesheet correctly

A timesheet may show 1.75 hours for a duration of one hour and 45 minutes. The digits after the point are fractions of an hour.

A decimal is not a clock display

In decimal hours, the fractional part is a fraction of sixty minutes. A value of 1.75 h means one full hour plus 0.75 of an hour. Since 0.75 × 60 = 45, it represents 1 h 45 min. It does not mean 1 hour 75 minutes. A clock notation such as 1:45 uses a colon and gives separate hour and minute fields. Distinguish these formats before copying numbers between a stopwatch, timesheet and spreadsheet. If a column lacks a unit or notation rule, ask for the format instead of guessing from the digits.

Work through 105 minutes

Take a task lasting 105 minutes. Divide by 60 to obtain 1.75 decimal hours. Splitting 105 into 60 + 45 gives the same duration as 1 h 45 min. To check the reverse route, multiply 1.75 by 60 and return to 105 minutes. The embedded minutes-to-hours converter lets you test this exact example. Another useful point is 30 minutes = 0.5 h, not 0.30 h. A hundredth of an hour is only 36 seconds, so two decimal digits can already hide small rounding differences.

One duration in three notations
  1. 105 minutes
  2. 1.75 decimal hours
  3. 1 hour 45 minutes

Durations and times of day

Elapsed time is a duration; 14:30 on a clock is a time of day. Subtracting a start time from an end time may require the date, time zone or daylight-saving transition if the interval crosses those boundaries. The unit converter only changes a known duration between hours, minutes and days. It cannot determine elapsed time from two ambiguous clock readings. Likewise, one day in the linked duration tool means 24 hours. A calendar date or local civil day can behave differently around a clock change, so label which meaning your data uses.

Avoid errors in a table

For a timesheet, store a consistent numeric duration, such as minutes, then convert for display or calculation. If one row holds 1:45 as text and another holds 1.75 as a number, blindly adding them can produce a wrong result. In a spreadsheet, check whether a cell is formatted as a time value or as an ordinary decimal number. Multiply decimal hours by 60 to get minutes; divide total minutes by 60 for decimal hours. Keep the original start and end records if you may need to audit an elapsed-time calculation later.

Round at the right stage

If a duration is measured to the nearest minute, calculate with all those minutes before rounding its decimal display. For example, 7 minutes is about 0.1167 h; showing 0.12 h introduces a small difference when reversed. Summing rounded decimal rows can differ from rounding the total once. Any billing or payroll rounding rule is a separate policy and should be applied explicitly after a correct duration is known. The converter does not choose that rule. Keep the unrounded duration available to explain why a displayed total may not equal the sum of already rounded entries.

A repeatable conversion check

Record the source duration and notation, for example 105 min = 1.75 h = 1 h 45 min. Use the embedded converter on the minute total, then multiply its decimal-hour result by 60 to check the original. For longer intervals, convert a 24-hour duration to one day, but do not silently equate it with a specific calendar date. When sharing a table, title columns Minutes, Decimal hours and Clock-style duration. These labels prevent a reader from treating 1.75 as 1:75 or 1.45 as one hour and 45 minutes.

Try the converter

Convert 105 elapsed minutes into decimal hours.

Convert minutes (min) to hours (h) with an instant calculator. See the exact formula (h = min ÷ 60) and copy the result.

Open full converter

More guides

Conversion guides

Explore guides