Duration is different from a timestamp
This converter works with elapsed durations: seconds, milliseconds, minutes, hours, fixed days and fixed weeks. It is useful for runtime logs, recorded intervals and rate calculations. It does not interpret dates, time zones, calendar months or the civil-clock adjustments that can make a local calendar day differ from an elapsed 24-hour interval.
A minute contains 60 seconds, an hour 3,600 seconds, and the day used here 86,400 seconds. Decimal hours are fractions of an hour: 1.5 hours means 1 hour 30 minutes, while 1 hour 50 minutes is approximately 1.83333 hours. A colon-separated clock notation must be converted to a decimal duration before entry.
Convert the minutes to a fraction of sixty before adding them to whole hours. The converter’s days are fixed 24-hour durations, not local calendar dates. A shift crossing a daylight-saving transition requires date and time-zone logic. Rounded billing intervals are a separate policy decision; the unit conversion should remain visible before any billing or reporting rule is applied.
Label the duration format in the spreadsheet and keep any rounding or billing rule separate from the conversion into hours.
- Establish whether the value is an elapsed duration or a clock time.
- Translate hours-and-minutes notation into decimal hours; do not enter the minutes as decimal digits.
- For rates, align the time denominator before combining quantities, such as hours with seconds.
Questions about time
Does a day always mean 24 hours here?
Yes. The unit d is a fixed duration of 86,400 seconds. A local calendar day spanning a daylight-saving transition can have a different elapsed duration and needs date/time-zone handling.
How do I convert 45 minutes into decimal hours?
Select minutes as the source and hours as the destination, then enter 45. The result is 0.75 hours, not 0.45 hours.
90 min in hours
90 min = 1.5 h
Output = input × source factor ÷ destination factor90 × 60 ÷ 3,600 = 1.5 h. The two factors express the source and destination relative to the same internal reference unit. Their ratio is the multiplier.
Both unit factors refer to the same internal reference for time. Multiplying by the source factor and dividing by the destination factor changes the numerical scale while retaining the quantity. The source definition still matters: One hour thirty minutes is 1.5 hours. Decimal digits represent a fraction of sixty minutes.
Reversing the unrounded 1.5 h result returns 90 min. Use this as a direction check. A consistent reverse calculation cannot resolve entering 1:30 as 1.30 hours or improve the original observation.
Make decimal hours unambiguous
For an equipment log, convert the recorded duration into the denominator used by the rate. A litres-per-minute rate must be paired with minutes, or converted together with the duration.
The following inputs stay in minutes and the results use hours. They illustrate different magnitudes for this measurement. Retain the specific conditions described above when replacing an example with your own value.
| Starting value | Equivalent value |
|---|---|
| 30 min | 0.5 h |
| 78 min | 1.3 h |
| 90 min | 1.5 h |
| 165 min | 2.75 h |
This time unit pair has a constant factor ratio. Changing the input changes the output by the same proportion. If a copied figure differs by an unexpected factor, review the full unit symbol before changing the source measurement. Months vary in length. Use actual dates for calendar intervals; this converter does not offer months.
Label the duration format in the spreadsheet and keep any rounding or billing rule separate from the conversion into hours.
Keep the duration separate from the payroll rule
A timesheet records one hour thirty minutes, while a spreadsheet expects decimal hours. Entering 1.30 is a tempting mistake: the decimal fraction means thirty hundredths of an hour, not thirty minutes. A consistent duration format matters whenever time is multiplied by a rate or compared across records.
One hour and thirty minutes is 1.5 hours. A value of 1.30 decimal hours is 78 minutes, which is twelve minutes shorter. Likewise, 2 hours 45 minutes is 2.75 decimal hours, not 2.45. The decimal portion represents a fraction of an hour, so multiply it by sixty when translating it back to minutes.
If a spreadsheet multiplies duration by an hourly rate, it must use the intended duration representation. A spreadsheet time-of-day value may internally be a fraction of a day rather than a number of hours. Its display format can conceal that distinction. Verify the cell's units before multiplying, and inspect a simple known duration such as thirty minutes.
Policies about minimum billing, paid breaks and rounded clock punches are independent of the mathematical conversion. Retain both the measured duration and the policy-adjusted duration when an audit needs to reconstruct the result. A fixed 24-hour day also differs from elapsed time between local timestamps across a daylight-saving transition. Date-aware calculations need the date, time zone and applicable clock rules; a duration converter supplies none of those calendar assumptions.
1 h 30 min = 1.5 h; 1.30 decimal hours = 78 min.
Time units, side by side
The values below all describe 90 min. They provide a comparison of unit sizes for time; they are not separate measurements. Read the complete symbol and convention before copying a number.
| Unit | Symbol | Equivalent |
|---|---|---|
| Seconds | s | 5,400 s |
| Milliseconds | ms | 5,400,000 ms |
| Minutes | min | 90 min |
| Hours | h | 1.5 h |
| Days | d | 0.0625 d |
| Weeks | wk | 0.00892857142857 wk |
Keep the original minutes record alongside the converted hours display. The unit list uses up to twelve significant digits for arithmetic readability, while the measurement precision still comes from its source.
What this time comparison can tell you
Useful capabilities
Label the duration format in the spreadsheet and keep any rounding or billing rule separate from the conversion into hours.
The listed units express the same supplied time quantity. The 90 min → 1.5 h example makes the selected convention visible before it is used in a longer calculation.
Important limits
A day here is exactly 24 hours. Calendar months and daylight-saving clock changes are excluded.
One hour thirty minutes is 1.5 hours. Decimal digits represent a fraction of sixty minutes. Months vary in length. Use actual dates for calendar intervals; this converter does not offer months.
| Possible mismatch | What resolves it |
|---|---|
| Entering 1:30 as 1.30 hours | One hour thirty minutes is 1.5 hours. Decimal digits represent a fraction of sixty minutes. |
| Treating a calendar month as a fixed duration | Months vary in length. Use actual dates for calendar intervals; this converter does not offer months. |
A time-of-day cell in a spreadsheet may store a fraction of a day rather than a count of hours. Confirm that representation before multiplying by a rate. Billing increments are a separate policy, and elapsed duration across a local clock change requires date-aware handling. A decimal-hours equivalent should retain the original minutes so that rounding and reporting decisions remain traceable.
As a controlled uncertainty example, suppose the original 90 min record had a stated ±1% input interval. Its endpoints would be 89.1 min and 90.9 min. Converting those endpoints gives an output interval from 1.485 h to 1.515 h. The interval scales with the same fixed unit ratio as the central value. This chosen interval illustrates the arithmetic and is not an accuracy claim for your measurement.