To convert an Excel time in cell A2 to total seconds, enter =A2*86400 in another cell and format the result as General or Number. Excel already stores a valid time as a number; multiplying by 86,400 changes its unit from a fraction of a day to seconds. Use 24 for decimal hours or 1,440 for total minutes instead.
What Excel means by an H:M:S value
Excel represents dates and times as serial numbers. The whole-number portion represents days, while the fractional portion represents the time within a day: midnight is 0, noon is 0.5, and 6 p.m. is 0.75. One day contains 24 hours, 1,440 minutes, or 86,400 seconds. That is why multiplying a time by one of those factors converts the stored value to the corresponding unit.
For example, 1:02:03 means one hour, two minutes, and three seconds. As a fraction of a day, it is approximately 0.0430903. That value may look like a small decimal if the cell is formatted as General, or like 1:02:03 if it has a time format. The underlying value is numeric in either case. A displayed time and a number are not competing representations; they are the same stored value shown with different number formats.
This distinction matters when people say they want to convert H:M:S to a number. They may want the underlying decimal, a count of elapsed seconds, decimal hours for calculations, or simply to see the serial value rather than a clock-style display. Choose the desired unit before choosing a formula.
Convert a time to seconds, minutes, or hours
Assume A2 contains a genuine Excel time or duration of 1:02:03. To return total elapsed seconds, with the time in A2, enter =A2*86400 in B2. The result is 3,723. To return total minutes, with the same input in A2, enter =A2*1440 in B2. The result is 62.05 minutes. To return decimal hours, with the same input in A2, enter =A2*24 in B2. The result is about 1.034166667 hours.
These are total units, not a breakdown into separate components. In the example, the minutes result is 62.05, rather than 2.05, because it includes the full hour. The decimal-hours result includes the hour, minutes, and seconds as a fraction. If you only want the hour component displayed in the original time, that is a different task from converting the whole duration to decimal hours.
After entering a conversion formula, select the result cell and choose Home > Number Format dropdown > General or Number. If the cell still has a time format, Excel may display the converted seconds as a clock-style value, which can make a correct calculation look wrong. Increase decimal places if you need to see fractional seconds or minute values.
Choose the right output for your task
Use the unit that matches the next calculation or the way you need to report the result:
- Seconds: Multiply by 86,400 for stopwatch readings, service durations, or second-based data.
- Minutes: Multiply by 1,440 when a process or report uses total minutes.
- Decimal hours: Multiply by 24 when you need a number such as 1.5 hours for a 1 hour 30 minute duration.
- Excel serial value: Use the original time value itself if another Excel calculation expects a fraction of a day.
For a quick comparison, 0:30:00 is 1,800 seconds, 30 total minutes, and 0.5 decimal hours. If you multiply it by 24, the formula does not return 30; it returns 0.5. If you multiply it by 86,400, it returns 1,800. The multiplier determines the unit, so label the output column clearly, such as Seconds, Total minutes, or Decimal hours.
Make sure the input is a real time, not text
A value that looks like 1:02:03 may be stored as text, especially if it was imported from a website, a CSV file, or another system. A quick clue is that text often sits at the left side of a cell under General formatting, while numbers are usually right-aligned by default. Alignment can be changed manually, so it is only a clue. You can also select the cell and inspect the formula bar or test a conversion; an error may indicate that Excel cannot interpret the input as a time value.
If A2 contains text that Excel can recognize as a time, and you want seconds in B2, enter =TIMEVALUE(A2)*86400. For text 1:02:03, this returns 3,723. TIMEVALUE converts a recognized time string into Excel’s time serial, and the multiplication converts that serial into seconds. Format B2 as General or Number to see the numeric result.
TIMEVALUE is intended for a time of day and cannot represent an elapsed duration whose hour count exceeds 23. For example, a text value of 27:15:00 is not a normal time of day. Do not assume the same text-conversion formula will handle such long durations. If the imported value is text and can exceed 24 hours, clean or parse the source into a numeric duration using a method designed for its specific format, then verify the result against a known example.
Handle durations longer than 24 hours
Excel can store elapsed durations longer than a day. If A2 contains a numeric duration of 27:15:00, the underlying value is 1.135416667 days. With that duration in A2, enter =A2*24 in B2 to get 27.25 total hours, or enter =A2*86400 to get 98,100 total seconds. These results count all the elapsed time rather than wrapping at midnight.
To display the original duration without resetting its hour count after 24 hours, format the cell with a custom elapsed-time format such as [h]:mm:ss. The square brackets around h tell Excel to show cumulative hours. Without them, a standard time format such as h:mm:ss can show 3:15:00 for a value of 27:15:00, because it displays the time within the day. That can be confusing, but it does not mean Excel has discarded the extra day.
Apply the elapsed format by selecting the duration cell, opening Format Cells, choosing Custom, and entering [h]:mm:ss as the type. On Windows, Ctrl+1 opens Format Cells. Excel for Mac uses Command+1. You can also use the Home tab’s Number group to open the format options. Keep the distinction clear: a custom format changes the display, while multiplying by 24 or 86,400 changes the unit in a calculation.
Why a result may look wrong
The most common issue is number formatting. If a result of 3,723 is shown as a time or date, select the result and choose General or Number. Another common source of confusion is using a display format such as mm:ss to infer the underlying total. A format can hide hours or days; it does not remove them from the stored value.
Check these points when the answer is unexpected:
- Confirm the input is numeric: Text values may need conversion before arithmetic works.
- Confirm the multiplier: Use 86,400 for seconds, 1,440 for minutes, and 24 for hours.
- Check for a date component: If the cell contains both a date and a time, multiplying the whole value includes the days since Excel’s date origin. Use a time-only value if you only want the time portion.
- Check the output format: General or Number reveals the converted numeric result.
- Check whether the duration exceeds a day: Standard clock formats can hide accumulated hours.
For a date-and-time value, the fractional part represents the time of day and the integer part represents the date. If A2 contains a date plus a time and you need only the seconds since midnight, with that combined value in A2, enter =MOD(A2,1)*86400 in B2. The MOD function keeps the fractional-day portion before converting it. This deliberately excludes the date; it is not the right formula for total seconds elapsed across multiple dates.
Use the value in later calculations
Once a duration is converted to a number, you can add, average, compare, or chart it as a quantity in the selected unit. Keep units consistent. For example, adding a seconds value to a decimal-hours value produces a mathematically valid number but a meaningless result. A useful worksheet design keeps the original time in one column and the converted value in a clearly labeled adjacent column, so the source remains available for checking.
For a range of durations, copy the conversion formula down alongside the source values. If A2:A10 contains numeric durations, place the seconds formula in B2 and fill it down; the relative reference adjusts to A3, A4, and so on. If the source values may contain text, resolve that issue consistently first rather than mixing text and numeric durations in the same calculation. For totals, sum the converted numeric column or sum the original durations and convert the total once. Both approaches can work when the inputs are all numeric and use the same units.
When you need to retain precision, do not round the conversion formula unless the task requires rounding. Formatting a result to show fewer decimal places changes only how many digits are displayed; it does not change the stored value. If a downstream export requires whole seconds, rounding or truncating is a separate decision that should match the receiving system’s rules.
Frequently Asked Questions
Is an Excel time already a number? Yes. A valid Excel time is stored as a fraction of a day. Formatting controls whether you see a time such as 1:02:03 or a decimal such as 0.0430903.
How do I convert H:M:S to seconds in Excel? If A2 contains a numeric time or duration, enter =A2*86400 in another cell and format the result as General or Number. For 1:02:03, the result is 3,723 seconds.
How do I convert a time to decimal hours? With a numeric time or duration in A2, use =A2*24. A duration of 1:30:00 returns 1.5 hours, not 1 hour and 30 minutes as separate fields.
Why does Excel show a date or another time after I multiply? The result cell probably has a date or time number format. Change it to General or Number to display the numeric conversion. The formula result may be correct even when the display is misleading.
How do I show 27 hours instead of 3 hours? Format the duration cell with [h]:mm:ss. The bracketed hour displays cumulative elapsed hours, while an ordinary clock format can wrap after 24 hours.
Can TIMEVALUE convert 30:00:00 text to a duration? TIMEVALUE is for recognizable times of day and is not a reliable way to convert text durations with hours above 23. Convert or parse long-duration text with a method suited to its exact source format, and validate the result before using it.
Related
- Insert an Image Into Excel: Steps and Options
- Can You Insert an Image Into an Excel Cell?
- Can You Delete Duplicates in Excel? Methods and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Get Data From Table or Range: A Practical GuideTo get data from a worksheet table or cell range into Power Query in Excel for Microsoft 365…
- Compare Two Sheets for Matches in Excel: A Practical GuideTo compare two Excel sheets for matching records, use a shared key such as an ID or email…
- Excel Cell Auto Adjust: How to Fit Width and Row HeightTo auto-adjust cells in Excel for Microsoft 365 on Windows, select the column or row, then double-click the…
- Detect Duplicates in Google Sheets: A Practical GuideTo detect duplicates in Google Sheets, select the cells you want to check, choose Format > Conditional formatting,…
- INDEX MATCH in Google Sheets: How It Works and ExamplesYes. Google Sheets supports both INDEX and MATCH, and combining them lets you find a value in one…
- Move a Row Up or Down in Excel Without Losing DataTo move a row in Excel without overwriting another one, click its row number, press Ctrl+X, then right-click…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.