Convert Time to Decimal (or Decimal to Time) – Excel & Google Sheets

This tutorial will demonstrate how to convert time values to decimal values (or vis-a-versa) in Excel and Google Sheets.

Convert Time to Decimal Main

Decimal to Time

In Excel, times are stored as decimal values where each 1/24th represents one hour:

Value Time

To convert a decimal value to time, all you need to do is adjust the Number Formatting to Time:

convert decimal to time format

Time to Decimal

If you have a time value, all you need to do is change the Number Formatting to General to see the decimal value:

time decimal format

If the time is stored as text, first you’ll need to use the TIMEVALUE Function before converting to decimal format:

TIMEVALUE Function

 

Times & Decimals in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.Convert Time to Decimal Google