How to Convert Time to Decimals in Excel (Formula)


- Written by Puneet

Excel stores time as a decimal; only format it as a time. With the help of formulas, you can convert that time into decimals; still, those decimals make sense to the user.

Time into Decimals (Hours – Minutes – Seconds)

  1. Enter (=) in a cell
  2. Refer to the cell where you have the time.
  3. Type an asterisk (*).
  4. Enter (24) and hit enter to get the result.

The cell where you enter this formula must have the cell format “Number” with two decimals.


And for:

  1. Whole Hours: =INT(A1*24)
  2. Minutes: =A1*1440
  3. Seconds: =A1*86400

Remove Format to Get the Decimal for a Time

  1. Select the cell.
  2. Open the Format Cell Option.
  3. Click General.
  4. Click OK to Save.

When you click OK, it converts that value into a decimal value.


Get the Excel File

Last Updated: December 01, 2023