To convert an Excel time to decimal hours, multiply the time value by 24: with a time such as 8:30 in A2, enter =A2*24 in another cell to get 8.5 hours. For decimal minutes multiply by 1,440; for decimal seconds multiply by 86,400. Excel stores times as fractions of a day, so these multipliers convert that fraction into the unit you need.
What Excel time means
Excel does not store a time such as 8:30 as the text “eight hours and thirty minutes.” It stores a number: the fraction of a 24-hour day that has elapsed. For example, 8:30 is 8.5 hours out of 24, or 0.3541667 of a day. A cell’s time format makes that underlying number appear as a clock time.
This distinction matters because the same value can be displayed in different ways. A value of 0.5 formatted as a time appears as 12:00 PM; formatted as a percentage, it appears as 50%; formatted as a decimal number, it appears as 0.5. Changing the format changes what you see, not the stored value. To get a decimal number of hours, you need to convert the stored fraction by multiplying by 24.
Excel dates use the whole-number portion of a serial value, while times use its fractional portion. A cell containing both a date and a time therefore has a larger value than a time alone. Whether you should convert the entire value or just its fractional part depends on whether you want elapsed time or only the time of day.
Convert a time to decimal hours
Assume A2 contains a valid Excel time of 8:30 AM. In B2, enter =A2*24. The result is 8.5, meaning eight and a half hours. The calculation works because 8:30 is 8.5 hours, and Excel’s stored fraction for that time is 8.5 divided by 24.
After entering the formula, format B2 as a number rather than a time. Select the cell and use Home > Number Format, then choose Number or General. If the result still appears as a clock reading, the formula may be right but the result cell is still using a time format. You can also open Format Cells with Ctrl+1 on Windows or Command+1 on Mac and select a number category.
For a column of entries, put the formula beside the first time and fill it down using the fill handle or copy and paste. Relative references update automatically: the formula in B3 will refer to A3. Keep the original time column if you may need to check the source values or display them as clock times elsewhere in the workbook.
Convert to decimal minutes or seconds
Use the corresponding number of units in a day as the multiplier. There are 1,440 minutes and 86,400 seconds in 24 hours. For a time of 8:30, multiplying the Excel value by 1,440 gives 510 minutes, while multiplying by 86,400 gives 30,600 seconds. These are total minutes or seconds since midnight when the input is a time of day; for a duration, they are the duration’s total minutes or seconds.
With an Excel time in A2, enter =A2*1440 to return decimal minutes; 8:30 returns 510. With the same layout, enter =A2*86400 to return decimal seconds; 8:30 returns 30600. Format each result as Number or General so Excel does not render the result as a time.
These conversions return whole numbers for times entered to the minute or second, but a time can contain fractions of a second. If the output needs a fixed number of decimal places, round it explicitly. With the time in A2, =ROUND(A2*24,2) returns 8.5 for 8:30, which you can display as 8.50 by setting the result cell to two decimal places. Rounding affects the calculated value, so use it only when that precision is appropriate.
Clock times versus elapsed durations
A clock time tells you where you are in a day; a duration tells you how long something lasted. The simple multiplication formulas work for either when the cell contains only the relevant time fraction. However, a clock time such as 2:00 AM is not itself a two-hour duration from a work shift’s start. To calculate a shift length, subtract the start time from the end time and handle shifts that cross midnight.
Durations longer than 24 hours need special attention. Excel can store them as a number of days plus a fractional day. For example, a duration of 27 hours and 30 minutes is 1 day plus 3 hours and 30 minutes. If the cell is formatted as an ordinary clock time, it may display only 3:30, hiding the full duration. Apply the custom number format [h]:mm to show accumulated hours, such as 27:30. The square brackets tell Excel to keep counting hours instead of restarting at 0 after each day.
With a duration in A2, =A2*24 returns the full number of hours even when the duration exceeds one day. If A2 represents 27:30, the result is 27.5. This is often the right approach for timesheets, equipment run times, or other totals. Avoid using HOUR(A2) for a total duration: that function returns the hour component within a day, so it would return 3 for 27:30 rather than 27.
Convert decimal hours back to Excel time
The reverse conversion divides decimal hours by 24. If B2 contains 8.5, enter =B2/24 in C2; the result is the Excel time value for 8 hours and 30 minutes. Format C2 with a time format such as h:mm to display 8:30. The formula result is still a fraction of a day underneath.
For decimal minutes, divide by 1,440; for decimal seconds, divide by 86,400. With decimal minutes in B2, =B2/1440 returns an Excel time value. A value of 510 displays as 8:30 when the result is formatted as h:mm. If the value represents a duration that may exceed a day, use a display format such as [h]:mm instead of h:mm so the total does not wrap at 24 hours.
Be clear about the source unit before converting back. A value of 8.5 could mean 8.5 hours, 8.5 minutes, or another decimal quantity; Excel cannot infer the intended unit. Label columns with units and choose the matching divisor to avoid plausible-looking but incorrect results.
Choose the right conversion for your data
The best formula depends on what the source cell represents and what the result should mean. Before filling a formula down a large table, check a few entries manually and confirm the unit labels. Useful choices include:
- Decimal hours: multiply a time or duration by 24. Use this for payroll or reporting calculations that need hours as a numeric quantity.
- Decimal minutes: multiply by 1,440 when downstream calculations use minutes.
- Decimal seconds: multiply by 86,400 for measurements or logs that need seconds.
- Time of day from a date-time value: if A2 contains a date and time but you want only its time-of-day fraction, use
=MOD(A2,1)*24. For a date-time of 8:30 AM, this returns 8.5. - Text that looks like a time: convert the text to a real time value before using the multiplication method, or use a conversion formula if the text is consistently recognizable.
For example, with text such as 8:30 AM in A2, =TIMEVALUE(A2)*24 returns 8.5 when Excel recognizes the text under the workbook’s regional settings. TIMEVALUE returns a fraction of a day, which is why the result is multiplied by 24. If the source text uses an unfamiliar format or includes extra words, clean or standardize it first rather than assuming the formula will interpret every text pattern.
Formatting and display choices
Formatting helps readers distinguish decimal hours from clock times. For decimal results, Number with a chosen number of decimal places is usually clear; a header such as Decimal hours makes the unit explicit. A result of 8.50 is numerically equivalent to 8.5, but the trailing zero can communicate that values are being presented to two decimal places. It does not make the measurement more precise than the original data.
For elapsed time, formats such as h:mm and [h]:mm are not interchangeable. The first displays the hour component on a 24-hour cycle, while the bracketed form displays accumulated hours. Use [m]:ss if you need total minutes and seconds for a long duration. Apply a custom format through Format Cells > Number > Custom, then enter the desired format in the Type box. A custom format changes display only; it does not convert the cell to decimal hours.
To make a decimal number look like a clock time, dividing by 24 is necessary; simply applying a time format to 8.5 will interpret 8.5 as days, not 8.5 hours. Conversely, multiplying a time value by 24 is necessary to get decimal hours; selecting a number format alone cannot perform that arithmetic.
Common problems and checks
- The result is a time instead of a decimal: the result cell likely has a time format. Change it to General or Number. The underlying calculation may already be correct.
- The formula returns an unexpectedly large number: the input may include a date. A full date-time serial multiplied by 24 includes all the days since Excel’s date origin. Use the MOD formula above only when the goal is to extract the time of day; keep the date portion when it is part of an elapsed-time calculation.
- The formula returns an error or zero: the source may be text rather than a numeric Excel time. A quick clue is that changing the cell’s number format does not alter its appearance. Convert the text to a valid time value or use TIMEVALUE for recognizable time text.
- The displayed duration loses hours after 24: use [h]:mm for the duration display. The stored value may be correct even though the ordinary clock format wraps.
- A negative result displays as hashes: Excel’s standard 1900 date system does not display negative time values as ordinary times. Check whether the subtraction order or overnight-shift logic is correct before changing workbook date-system settings, which can affect date values throughout the file.
For an overnight shift, subtracting an end time earlier than a start time produces a negative value unless the formula accounts for the next day. In a simple case where A2 is the start and B2 is the end, the formula =MOD(B2-A2,1)*24 returns the elapsed hours across midnight. If the shift spans more than one day, times alone do not contain enough information to identify the number of days; record dates as well as times and calculate the full date-time difference.
Frequently Asked Questions
How do I convert 7 hours and 30 minutes to decimal hours in Excel?
Enter a valid Excel time such as 7:30, then multiply its cell value by 24. The result is 7.5 hours. If you already have separate hour and minute numbers, calculate the decimal hours by adding the hours to the minutes divided by 60.
Why does Excel show 0.5 instead of 12:00?
Excel stores noon as half of a day, or 0.5. If the cell is formatted as General or Number, Excel displays that stored value. Apply a time format to show 12:00, or multiply by 24 if you want decimal hours, which gives 12.
How do I show total hours above 24?
Format the duration cell with the custom format [h]:mm. An ordinary h:mm display starts over at 0 after 24 hours, while the bracketed hour format keeps accumulating. Multiply the duration by 24 in a separate number-formatted cell to return its decimal-hour total.
Can I convert decimal hours such as 7.25 back to a time?
Yes. Divide 7.25 by 24 and format the result as h:mm. It represents 7 hours and 15 minutes, because the quarter-hour portion is 0.25 of an hour.
Does changing the cell format convert time to decimal?
No. Formatting changes how a value appears, not its unit or underlying value. Multiply by 24, 1,440, or 86,400 to calculate decimal hours, minutes, or seconds, then format the result as a number.
Related
- Excel Data Validation Icon: What It Looks Like and Does
- Data Validation Multiple Selection in Excel: What Works
- Data Validation Interview Questions and Strong Answers
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Power Query Editor: How to Open ItIn Excel for Microsoft 365 on Windows, open the Power Query Editor from Data > Get Data >…
- How to Set Out of Office in Outlook and Webex on Any DeviceTo set an out-of-office message in Outlook, turn on Automatic Replies and enter the message and dates; in…
- Hide Excel Columns Based on Cell Values AutomaticallyTo hide Excel columns when a cell contains a chosen value, use a short VBA macro that checks…
- Find and Replace Font in Word: Full Steps and TipsTo find and replace a font in Word for Microsoft 365 on Windows, press Ctrl+H, select More, then…
- Box Plot in Excel 2007: How to Build One ManuallyExcel 2007 has no built-in Box and Whisker chart type, so you cannot create one through the chart…
- Excel Keyboard Shortcut to Split a CellIn Excel for Microsoft 365 on Windows, press Alt, H, M, U to unmerge a selected merged cell.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.