Converting Time to Decimals in Excel

Excel stores time as decimals and only formats it as time. However, you can use formulas to convert time into decimals that make sense to the user.

Converting Time to Decimals in Excel

To convert time into decimals for hours, minutes, and seconds, follow these steps:

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

   Converting Time to Decimals in Excel

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

You can also convert time into decimals for whole hours, minutes, and seconds using the following formulas:

• Whole hours: =INT(A1*24)
• Minutes: =A1*1440
• Seconds: =A1*86400

To remove the format and get the decimal value for a time, follow these steps:

1. Select the cell.
2. Open the “Format Cell” option.
3. Click “General.”
4. Click “OK” to save.

Once you click “OK,” it will convert the value into a decimal value.