To convert time to hours for an Excel worksheet, use the Time Converter for any supported unit, or multiply a valid Excel clock-time cell by 24 with the formula =A1*24. Excel stores clock times as fractions of a day, while a spreadsheet may also contain a plain duration recorded in minutes, milliseconds, or another unit. Those sources need different handling: the *24 formula is designed for an Excel clock-time serial, whereas a numeric duration should be divided or multiplied by the unit relationship you need. The Time Converter removes that source ambiguity because you enter one quantity, choose its source unit, and read the equivalent hours directly from a live results grid. It covers ten units from nanoseconds to years, recalculates while you type, and runs locally in your browser without an account or upload. Use the Excel formulas when you need a live worksheet calculation; use the converter when you want a unit result to compare against Excel or a value to enter into a cell after reading the output.
Identify what the Excel cell contains
The correct formula depends on how Excel is storing the value. Start by identifying the source rather than assuming every time value has the same format.
| Source in Excel | What it represents | Excel approach |
|---|---|---|
| A valid clock time in one cell | A fraction of a 24-hour day | Use =A1*24, then apply a Number format |
| Hours, minutes, and seconds in separate cells | Three clock components | Use =TIME(A1,A2,A3)*24 |
| A plain number with a known unit | A duration rather than a clock serial | Use =CONVERT(A1,"days","hours") for compatible units |
A value already measured in hours does not need conversion. A number intended to mean minutes should not be treated as an Excel clock value merely because it appears beside a time-related label. Confirming the cell type first prevents a formula from returning an unexpected date, clock display, or error.
Convert an Excel time cell to hours
- Open the workbook and click the cell containing the time. Check the formula bar and confirm that Excel has recognized it as a numeric time value rather than text.
- Select an empty cell where the decimal-hour result should appear.
- Enter =A1*24, replacing A1 with the source cell’s address, and press Enter.
- If the result appears as a clock or date instead of a decimal number, apply a Number format to the result cell. The multiplication produces a number; the cell format controls how that number is displayed.
- Check the formula bar for the underlying value. If the cell shows too few decimal places, increase the displayed precision without replacing the formula.
If the source contains both a date and a clock time, multiplying by 24 gives the total hours represented by the stored value, including whole-day portions. When you need only the clock portion, use the component formula in the next section instead.
Handle separated hours, minutes, and seconds
If the hour is in A2, the minute is in A3, and the second is in A4, enter =TIME(A2,A3,A4)*24. The TIME function creates a fraction of one day from the three components, and multiplying that fraction by 24 produces decimal hours.
When all clock components are already combined in a valid time cell, you can also use =HOUR(A1)+MINUTE(A1)/60+SECOND(A1)/3600. This version reads the hour, minute, and second directly, making it useful when the worksheet must exclude the date portion. The first formula is more compact, while the second makes each component’s contribution visible.
Use CONVERT for a plain duration
When a cell holds a numeric duration and both its source and target units are known, Excel’s CONVERT function can rescale it directly. For example, =CONVERT(A1,"days","hours") treats A1 as a number of days and returns its equivalent in hours. Change the quoted unit names to match the actual source and destination units.
Microsoft’s Excel guidance notes that conversions involving a year use a 365.25-day year. The Time Converter follows the same year convention and explicitly identifies both months and years as averages. Use CONVERT when one worksheet formula is enough; use the Time Converter when one source value must be understood across all ten supported units.
Convert one value with the Time Converter
- 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 use exact definitions, while months and years use average lengths of 365.25 days per year and 30.4375 days per month.
The grid updates as the input changes, so results recalculate live as you type. Each run handles one time value and presents its equivalents across nanoseconds, microseconds, milliseconds, seconds, minutes, hours, days, weeks, months, and years. The free converter performs the arithmetic locally in your browser, uploads no data, requires no account, and makes no server round trip. It can also work offline once the page has loaded.
Worked example: 90 minutes to hours
Formula: hours = minutes ÷ 60.
Substitution: hours = 90 ÷ 60.
Result: 1.5 hours.
For a plain numeric value of 90 minutes in Excel cell A1, =A1/60 gives the same 1.5-hour result. In the Time Converter, enter 90 in the Value field, choose Minutes as the source unit, and read the result as 1.5 hours. You can then enter that result in the worksheet. If the source cell must continue updating, retain a worksheet formula rather than replacing it with a fixed converted value.
Know which units use exact definitions
The converter normalizes each unit to a common seconds value and applies value × seconds[from] ÷ seconds[to]. The definitions below determine whether a result is exact or an average.
| Unit | Definition used by the converter | Status |
|---|---|---|
| Nanosecond | 1/1,000,000,000 of a second | Exact |
| Microsecond | 1/1,000,000 of a second | Exact |
| Millisecond | 1/1,000 of a second | Exact |
| Second | Base unit | Exact |
| Minute | 60 seconds | Exact |
| Hour | 3,600 seconds | Exact |
| Day | 86,400 seconds | Exact |
| Week | 604,800 seconds | Exact |
| Month | 30.4375 days, or 2,629,800 seconds | Average |
| Year | 365.25 days, or 31,557,600 seconds | Average |
The averages smooth real calendar variation rather than describe a specific date range. Calendar months range from 28 to 31 days, and leap days affect the length of a year. Treat converted month and year results as mean values. The note beneath the results grid makes this distinction visible before you transfer the number to Excel.
Check the result before entering it in Excel
- Confirm that the source is a clock value before using =A1*24. For a plain numeric duration, use CONVERT or the appropriate unit relationship.
- Check that the cell is stored as a number. A time entered as text may not calculate as expected, so convert or store it as a numeric value first.
- Apply a Number format to a decimal-hour result. A Time format can make the answer appear to be a clock rather than a number of hours.
- Increase decimal places when precision matters. Formatting changes how the value is presented, while the formula remains responsible for the calculation.
- Check whether the unit is a month or year. Those outputs are averages rather than calendar-specific durations.
For a deeper explanation of Excel’s time serial values and decimal-hour formatting, see how to convert time to decimal in Excel.
Choose the right kind of time tool
The Time Converter only rescales one quantity from one unit to another. It does not measure the elapsed interval between two specific clock times or dates, and it does not shift a single moment between world regions. Those are separate tasks: a duration calculator handles elapsed intervals, while a time-zone converter handles regional clock times.
If the Excel cell must update whenever its source changes, keep the worksheet formula. If you are converting one fixed duration or comparing it across all ten units, use the Time Converter and enter the displayed hours value where needed. If the question concerns how much time passed or what time it is in another region, choose the tool designed for that calculation.