Let's say you want to find out how many hours there are in five and a half days, or how many days there are in 3.45 years, or how many months have passed between a beginning date and an ending date. There are several ways to convert times.
What do you want to do?
Convert between time units
To do this task, use the CONVERT function.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

A 
Data 
6 
Formula 
Description (Result) 
=CONVERT(A2,"day","hr") 
Convert 6 days to hours (144) 
=CONVERT(A2,"hr","mn") 
Convert 6 hours to minutes (360) 
=CONVERT(A2,"yr", "day") 
Convert 6 years to days (2191.5) 

Note For conversions using a year, a year is treated as 365.25 days.
Function details
CONVERT
Top of Page
Convert hours from standard time format (hours : minutes : seconds) to a decimal number
To do this task, use the INT function.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

A 
Time 
10:35 AM 
12:15 PM 
Formula 
Description (Result) 
=(A2INT(A2))*24 
Number of hours since 12:00 AM (10.583333) 
=(A3INT(A3))*24 
Number of hours since 12:00 AM (12.25) 

Function details
INT
Top of Page
Convert hours from decimal number to the standard time format (hours : minutes : seconds)
To do this task, use the divisor operator (/) and the TEXT function.
Example
The example may be easier to understand if you copy it to a blank worksheet.
How to copy an example
 Create a blank workbook or worksheet.
 Select the example in the Help topic.
Note Do not select the row or column headers.
Selecting an example from Help
 Press CTRL+C.
 In the worksheet, select cell A1, and press CTRL+V.
 To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

A 
Hours 
10.5833 
12.25 
Formula 
Description (Result) 
=TEXT(A2/24, "h:mm") 
Hours since 12:00 AM (10:35) 
=TEXT(A3/24, "h:mm") 
Hours since 12:00 AM (12:15) 

Note You can also apply the time format without using the TEXT function to specify the format. To view the number as a time, select the cell, and on the Home tab, in the Number group, click the arrow next to the Number Format box, click More Number Formats, click Custom in the Category list, and then click a custom format in the Type box. However, if you use both a format applied with the TEXT function and number format, the TEXT function takes precedence.
Function details
TEXT
Top of Page