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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on August 28, 2023
Download Example Workbook

Download the example workbook

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 Funktion

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(B3)

TIMEVALUE Function

Times & Decimals in Google Sheets

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

GOOGLE GIF

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

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

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List