Convert hh:mm:ss, decimal hours, decimal minutes, total seconds, spreadsheet day fractions.
Last updated
Hours, minutes, seconds, and decimal time converter Convert between hh:mm:ss, decimal hours, decimal minutes, and total seconds with payroll, spreadsheet, and elapsed-time context kept visible.
Input mode
Quick presets
Payroll and spreadsheet checkpoints
15 min = 0.25 h, 30 min = 0.5 h, and 45 min = 0.75 h. For exact spreadsheet conversion, use hours + minutes ÷ 60 + seconds ÷ 3,600 rather than reading `1:30` as `1.30`.
Formatting rule
Hours can run above 24 because this page converts elapsed duration, not wall-clock time. Minutes and seconds still need to stay below 60 when you type hh:mm:ss directly.
Billed or reported duration preview
Use this preview for invoices, timesheets, or service logs that need a reporting increment. Keep the exact conversion above when the destination system does not apply a rounding policy.
Result
01:30:00
Exact equivalent: 1.5 decimal hours, 90 decimal minutes, and 5,400 total seconds.
Decimal hours
1.5 h
Decimal minutes
90 min
Total seconds
5,400 s
Nearest quarter hour
1.5 h
Nearest tenth hour
1.5 h
8-hour shifts
0.1875 shifts
Fraction of day
0.0625
Reported duration
01:30:00 (1.5 h)
Rounding difference
+0 min
Interpretation Composite input is exact elapsed time. The decimal-hour and decimal-minute outputs are the machine-friendly forms most payroll, spreadsheet, and reporting systems expect.
Study and runtime context
This span covers 3.6 Pomodoro blocks,
1.8 standard 50-minute class blocks,
and 0.1875 8-hour work shifts.
If a spreadsheet stores the duration as a real time value in A2, decimal hours are A2 × 24, decimal minutes are A2 × 1,440, and seconds are A2 × 86,400. If the source is text, split the hours, minutes, and seconds first so 1:30 is not misread as 1.30.
Hours, minutes, and seconds converter: HH:MM:SS, decimal hours, minutes
An hours-minutes-seconds converter helps when a time span needs to move between the way people write it and the way systems calculate it. That usually means switching between a composite clock-style value such as 01:30:00 and a decimal value such as 1.5 hours or 5,400 seconds.
Why HH:MM:SS and decimal hours both matter
Clock-style notation is easier for people to read because it matches the way schedules, timers, and media runtimes are usually written. Decimal hours are easier for payroll, spreadsheets, and reporting because they let you add, multiply, and round time spans directly.
That is why the page shows both views at once. A study session can be written as 01:45:00, a payroll system may want 1.75 hours, and a technical log might prefer 6,300 seconds. They all describe the same elapsed span.
How the conversion works
The converter treats seconds as the base elapsed-time unit. A composite input is parsed into hours, minutes, and seconds, translated into total seconds, and then expressed again as decimal hours and decimal minutes.
The same idea works in reverse for decimal-hour input: the value is converted to seconds first and then reformatted as HH:MM:SS. Composite entries still have to obey clock-style rules, so the minutes and seconds parts must stay below 60.
Builds a single elapsed-time total from a composite HH:MM:SS entry.
Decimal hours = Total seconds ÷ 3,600
Converts the same span into the decimal form often used by payroll and spreadsheets.
Where this is useful in practice
Quarter-hour payroll rounding, revision blocks, class lengths, and media runtimes are common cases. A 01:30:00 meeting becomes 1.5 decimal hours. A 00:25:00 focus block becomes 0.4167 hours. An 08:45:00 shift becomes 8.75 hours before any site-specific rounding policy is applied.
The page also keeps the decimal-minute and total-second views visible so you can move between productivity systems, logs, and applications without repeating the calculation.
Exact conversion is not the same as payroll rounding
An HMS converter gives the exact elapsed-time equivalent. Payroll and invoicing systems often apply a second step after that exact conversion, such as rounding to the nearest quarter hour or nearest tenth of an hour. Those policies are not part of time itself. They are reporting rules layered on top of an exact duration.
That distinction matters because 01:34:00 converts exactly to about 1.5667 hours, but a payroll system might record it as 1.5 or 1.6 hours depending on the local policy. A useful hours minutes seconds converter should therefore show the exact decimal value and the common rounded checkpoints side by side instead of treating them as the same thing.
When decimal minutes and total seconds are the better input
Decimal minutes are common in media work, stopwatch logs, classroom timing, and service tickets because they stay close to how people talk about short spans. Total seconds are common in code, APIs, telemetry, and technical logs because they are easy for software to store and compare.
That is why a practical HH:MM:SS converter should not force every user through the same entry style. Some people start with composite time, others start with decimal hours, decimal minutes, or raw seconds and need the human-readable version back.
Spreadsheet, database, and timesheet hand-offs
Spreadsheet programs often store a time duration as a fraction of a day. If a real duration value sits in a cell, multiplying it by 24 exposes decimal hours, multiplying by 1,440 exposes decimal minutes, and multiplying by 86,400 exposes total seconds. That is a different workflow from parsing a plain text string such as 01:30:00, where the hours, minutes, and seconds need to be split or recognised before the arithmetic is safe.
Databases, APIs, and telemetry exports often choose total seconds or milliseconds because a single number is easy to sort, aggregate, and compare. Timesheets and invoices usually prefer decimal hours because pay rates and billing rates multiply cleanly. A useful HMS converter therefore shows the exact human-readable duration, the decimal values, and a reporting-rounding preview without hiding which value is exact and which value is policy-driven.
Decimal hours from a real spreadsheet duration = cell value × 24
Works when the spreadsheet already recognises the cell as an elapsed duration rather than plain text.
Total seconds from a real spreadsheet duration = cell value × 86,400
Converts the same day-fraction storage model into the raw seconds often used by databases and logs.
Durations can run past 24 hours
An elapsed duration is not the same thing as the time showing on a clock face. A runtime, shift total, or project log can easily exceed 24 hours, which is why values such as 27:15:00 are valid in an elapsed-time converter even though they are not valid wall-clock times of day.
That matters for spreadsheets and exported logs because many users need to convert long-form elapsed durations into decimal hours without losing the fact that the span passed one or more full days.
Choosing a rounding increment
Exact conversion should happen before rounding. Once the exact duration is known, a reporting rule can round the result to an increment such as 5 minutes, 6 minutes, 10 minutes, 15 minutes, or 30 minutes. Nearest-increment rounding is common for summaries, while round-up rules can appear in billing workflows and round-down rules can appear in conservative reporting workflows.
The calculator's billed-duration preview is deliberately labelled as a preview because rounding rules belong to the destination system. It helps you compare the exact HH:MM:SS value with the value a timesheet, invoice, or service log might record, but the exact conversion remains the source value for audit or reconciliation.
Frequently asked questions
How many decimal hours is 1 hour 30 minutes?
1 hour 30 minutes equals 1.5 decimal hours because 30 minutes is half of one hour. The same span is also 90 minutes or 5,400 seconds.
Why does the converter reject 1:90:00?
Because composite time notation treats the middle and final fields as minutes and seconds, and those parts must stay below 60. 1:90:00 should instead be entered as 2:30:00 or as a decimal-hour value.
Is decimal-hours conversion the same as payroll rounding?
Not always. Decimal conversion is exact. Payroll systems may then apply a site-specific rounding rule such as the nearest quarter hour or tenth of an hour, which is a separate policy decision.
Can this convert decimal minutes back into hh:mm:ss?
Yes. Decimal minutes can be expanded back into hours, minutes, and seconds so a stopwatch, runtime, or service-log value becomes easier to read in composite form.
Can I enter total seconds instead of hh:mm:ss?
Yes. Total seconds are often the most natural format for code, telemetry, and technical logs. Converting them back into HH:MM:SS makes the same elapsed span easier for people to scan.
Does this work for durations longer than 24 hours?
Yes. This page converts elapsed duration, not wall-clock time of day, so values greater than 24 hours are valid and useful for long runtimes, shift totals, and aggregated logs.
What is 45 minutes in decimal hours?
45 minutes equals 0.75 decimal hours because 45 divided by 60 is 0.75. That is also why 15 minutes equals 0.25 hours and 30 minutes equals 0.5 hours.
What does multiplying a spreadsheet duration by 24 do?
Many spreadsheets store a real time duration as a fraction of a day. Multiplying that value by 24 converts the day fraction into decimal hours. Multiplying by 1,440 converts it into decimal minutes, and multiplying by 86,400 converts it into total seconds.
Why is 1:30 not the same as 1.30 hours?
The colon version uses base-60 time fields, so 1:30 means 1 hour and 30 minutes, which is 1.5 decimal hours. The decimal version 1.30 means 1.3 hours, which is 1 hour and 18 minutes.
How do I round a duration up to a billing increment?
Convert the duration exactly first, then apply the billing increment. For example, 47 minutes is 0.7833 exact decimal hours. Rounded up to a 15-minute increment, it becomes 60 minutes, or 1.0 billed hour.
What does fraction of day mean?
Fraction of day expresses the elapsed duration against a 24-hour day. One hour is 1 ÷ 24, or about 0.0417 of a day. This view is useful when reconciling spreadsheet time storage or systems that treat durations as day fractions.
How should I enter 1 hour and 90 minutes?
Convert the carry-over minutes before entering a composite value. One hour plus 90 minutes is 2:30:00, not 1:90:00, because HH:MM:SS uses base-60 minutes and seconds fields. You can also enter the same span as 2.5 decimal hours, 150 decimal minutes, or 9,000 total seconds.
What spreadsheet formula converts HH:MM:SS to decimal hours?
The exact idea is hours + minutes divided by 60 + seconds divided by 3,600. In spreadsheets that already recognise the value as a time duration, multiplying by 24 is also a common way to expose the decimal-hour equivalent.
