Convert minutes to time
This tutorial shows how to convert minutes into time by using a basic arithmetic formula
Excel
Hard coded formula
Cell reference formula
|
=30/1440
=B5/1440
|
GENERIC FORMULA
=minutes/1440
ARGUMENTS GENERIC FORMULA
=minutes/1440
ARGUMENTS 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 |
|---|---|---|
| Convert hours to time | How to convert hours to time | |
| Add minutes to time | How to add minutes to time | |
| Subtract minutes from time | How to subtract minutes from time |