Convert minutes to time

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

EXCEL FORMULA 1. Convert minutes to time

EXCEL

Hard coded formula
Convert minutes to time
Cell reference formula
Convert minutes to time
=30/1440
=B5/1440
GENERIC FORMULA

=minutes/1440

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

GENERIC FORMULA

=minutes/1440

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

EXPLANATION

This formula uses a simple arithmetic formula to convert minutes into time. It takes the minutes that you want to convert to time and divide it by the number of minutes in a day (1440). Please note that to show the time (results) 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 minutes directly entered into the formula or referenced to a specific cell.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to convert hours to time
How to add minutes to time
How to subtract minutes from time