Convert hours to time

This tutorial shows how to convert hours into time by using a basic arithmetic formula

Excel

EXCEL FORMULA 1. Convert hours to time

EXCEL

Hard coded formula

Cell reference formula

=1/24

=B5/24

GENERIC FORMULA

=hours/24

ARGUMENTS
hours: A number that represents hours that you want to convert to time.

GENERIC FORMULA

=hours/24

ARGUMENTS
hours: A number that represents hours that you want to convert to time.

EXPLANATION

This formula uses a simple arithmetic formula to convert hours into time. It takes the hours that you want to convert to time and divide it by the number of hours in a day (24). Please note that to show the time (results) in hours longer than 24 hours you will need to apply the [h]:mm format.

Click on either the Hard Coded or Cell Reference button to view the formula that has the hours directly entered into the formula or referenced to a specific cell.

Related Topic	Description	Related Topic and Description
Add hours to time	How to add hours to time
Subtract hours from time	How to subtract hours from time