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:


AutoMacro - VBA Code Generator

Times & Decimals in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.


Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!