Convert Time to Hours – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on September 8, 2023
Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to convert a time value to hours in Excel & Google Sheets.

Convert Time to Hours Main Function

Convert Time to Hours – Excel

Excel stores time as a decimal value where each 1/24th represents one hour of a day. Understanding this, you can convert a time to hours by multiplying the time by 24:



Convert Time to Hours - Value

Format as Number

When you multiply time by 24, Excel may format the result as time (ex. h:mm):


To display the result as a regular number, change the formatting to General:

Format Change Hour

Convert Time to Hours in Google Sheets

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

Convert Time to Hours Google

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