Excel converts time to decimal in a single step: multiply the time cell by 24 to get decimal hours, because the program stores every time value as a fraction of a 24-hour day. A cell containing 7:45 reads 7.75 after =A1*24, the same multiplier pattern produces decimal minutes when you swap 24 for 1,440, and decimal seconds when you use 86,400. The HOUR, MINUTE, and SECOND functions let you split the value into named components, so =HOUR(A1) + MINUTE(A1)/60 + SECOND(A1)/3600 arrives at 7.75 from the other direction. All three approaches give the same answer because they are the same arithmetic in different clothes — the question is which form is easier to read in your specific sheet. The rest of this guide walks through the formulas, the formatting traps, and when a dedicated browser tool replaces the spreadsheet entirely.
How Excel Stores Time Values
Every time you enter 9:30 into an Excel cell, the program quietly stores that value as 9.5/24 = 0.39583333... That decimal is the fraction of a full 24-hour day that has elapsed since midnight. The cell display, "9:30", is just a cosmetic format on top of the underlying number. This is why a one-line formula converts time to decimal: you are simply undoing the divide-by-24 that Excel did when it stored the value, and substituting the unit you actually want to recover.
The same logic flows upward. Multiplying by 1,440 unwinds a full day's worth of minutes (24 × 60 = 1,440). Multiplying by 86,400 unwinds a full day's worth of seconds (24 × 60 × 60 = 86,400). For sub-second units, the relationships stay exact because a second is a fixed SI unit: 1,000 milliseconds, 1,000,000 microseconds, 1,000,000,000 nanoseconds. Excel does not natively store milliseconds or nanoseconds as time values, but once you have a decimal-seconds number you can multiply it by 1,000 for milliseconds without any loss of precision.
Converting Time to Decimal Hours in Excel
The fastest way to convert any time cell into decimal hours is a single multiplication. Use this sequence whenever a payroll, billing, or project-tracking sheet needs a numeric hour value rather than a clock-style display.
- Enter your time value in cell A1 using Excel's time format — type 7:45 and press Enter, then verify the cell shows a left-aligned time rather than text.
- In cell B1 type the formula =A1*24 and press Enter.
- Right-click B1, choose Format Cells, and select Number with two decimal places so Excel does not display the result as another time value.
- Copy B1 down the column to apply the same conversion to every row in the data range.
With A1 holding 7:45, =A1*24 returns 7.75, because Excel first reads 7:45 as 7.75/24 = 0.3229166... and then multiplies by 24 to recover 7.75. The same A1 cell can be split into named components using =HOUR(A1) + MINUTE(A1)/60 + SECOND(A1)/3600, which returns the identical 7.75 but lets you audit each part of the time. The component form is useful when a column mixes times like 7:45 with 7:45:30, where the second formula correctly adds 30/3600 = 0.00833...
Converting to Decimal Minutes and Seconds
For payroll and timesheet work, decimal minutes are often more convenient than decimal hours because each minute stays an integer unit. Swap the multiplier from 24 to 1,440 to turn 7:45 into 465 minutes: type =A1*1440 in B1 and format the cell as Number. For elapsed-time logging in scientific or performance contexts, decimal seconds is the standard: =A1*86400 turns 7:45 into 27,900 seconds, which equals 7 hours × 3,600 plus 45 minutes × 60. The three multipliers — 24, 1,440, and 86,400 — cover virtually every time-to-decimal scenario a regular Excel user runs into.
When a column already contains separate hour, minute, and second values across three cells (A1 hours, B1 minutes, C1 seconds), skip the time-format step entirely: =A1 + B1/60 + C1/3600 builds decimal hours from raw integers. The same pattern generalizes to minutes and seconds by changing the divisor, which keeps the math readable for anyone later auditing the sheet.
Common Pitfalls and Edge Cases
The most common reason a formula returns a strange number is that the source cell holds text, not a time value. If the formula bar shows "7:45" with a small green triangle in the upper-left corner of the cell, Excel is reading it as text and your =A1*24 will produce a #VALUE! error. Wrapping the source with TIMEVALUE fixes the issue: =TIMEVALUE(A1)*24 converts the text to a real time value before multiplying.
Another pitfall is the result cell inheriting the source cell's time format. If =A1*24 displays "7:45" again instead of 7.75, Excel is treating 7.75 as 7.75 hours and rendering it through a clock-style mask. Reformatting the result cell to Number reveals the decimal value underneath. Hours greater than 24 also behave differently: Excel sees 25:00 as 1 day plus 1 hour, so =A1*24 still works, but if you intend the entry as a duration rather than a clock time you must enter the duration with a custom [h]:mm format that allows hours to roll past 24 without spilling into the next day.
For scientific work involving milliseconds, microseconds, or nanoseconds, Excel stops being convenient. A value like 3.2 microseconds is too small for the time-formatting system, so it is usually stored as a plain number. Multiplying the underlying decimal-seconds number by 1,000,000 converts to microseconds, and by 1,000,000,000 for nanoseconds. These conversions are exact because the sub-second units are powers of ten, with no calendar averaging involved.
When a Browser Tool Beats a Spreadsheet
Excel shines when the same conversion runs across thousands of rows in an existing workbook, but it is the wrong tool when you have a single number and need to see its equivalent in every time unit at once. For those moments, the Time Converter opens directly in your browser and shows a single value across ten units — nanoseconds, microseconds, milliseconds, seconds, minutes, hours, days, weeks, months, and years — without writing a formula. Type 90, pick minutes, and the grid immediately reports 1.5 hours, 5,400 seconds, and approximately 0.000171 years, letting you eyeball the relationship between units that would otherwise require three separate formulas. The same approach lets you check an Excel-derived result the other way: if your sheet says a job will take 0.0625 days, the converter shows it is exactly 90 minutes or 5,400 seconds, which is a fast sanity check on the spreadsheet math.
Using the Time Converter Step by Step
- Type the number you want to convert into the Value field.
- Choose the unit that number is measured in from the From unit dropdown.
- Read the equivalent amount in every other unit from the results grid — it recalculates live as you type.
- Check the note below the grid: seconds through weeks are exact, while months and years use average lengths (365.25 days per year, 30.4375 days per month).
The grid updates on every keystroke, so you can experiment freely — switch the From unit between hours and minutes and watch the seconds field change accordingly. Everything runs locally in the browser, so internal billing or payroll figures stay on the device. For a deeper walkthrough of converting time values to decimal hours, minutes, and seconds outside Excel, the decimal time conversion guide covers the same ideas in a spreadsheet-free context.
Time Conversion Constants at a Glance
The math behind Excel's time formulas and any external converter rests on the exact relationships between time units. The table below summarizes the constants that drive every conversion discussed above.
| Unit | Seconds (exact) | Notes |
|---|---|---|
| 1 second | 1 | SI base unit |
| 1 minute | 60 | Exact constant |
| 1 hour | 3,600 | 60 × 60 |
| 1 day | 86,400 | 24 × 3,600 |
| 1 week | 604,800 | 7 × 86,400 |
| 1 month (average) | 2,629,800 | 30.4375 days (year ÷ 12) |
| 1 year (average) | 31,557,600 | 365.25 days, Julian convention |
The seconds column matches the multipliers used in Excel's time math: 3,600 is 60 × 60 (seconds per hour) and explains why multiplying a time value by 24, then by 60, yields decimal minutes. Months and years are deliberately listed as averages because real calendar months run 28 to 31 days and leap years add an extra day every four years. In a unit-conversion context the Julian-year average of 365.25 days is the standard convention, and the Time Converter marks these rows as averages so a converted "1 month" is never mistaken for a specific date range.
Choosing between Excel and a browser tool comes down to scale. For a payroll sheet with thousands of rows, formulas are mandatory because they update dynamically when source data changes. For a one-off check, an ad-hoc billing calculation, or any answer that crosses into months or years, the Time Converter handles the full unit set in one view. Pairing the two — formulas for the workbook, converter for the cross-check — covers every time-to-decimal question Excel users actually run into.
If you're weighing options, Calculate Time Duration in an Excel Sheet covers this in detail.