How to Convert Time to Decimals in Excel (Formula)

puneet-gogia-excel-champs

- 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.
convert-time-into-decimals

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

cell-format-number

And for:

  1. Whole Hours: =INT(A1*24)
  2. Minutes: =A1*1440
  3. Seconds: =A1*86400
whole-hours-minutes-and-seconds

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.
cell-format-as-general

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

time-value-into-decimal-value

Get the Excel File

Last Updated: December 01, 2023