I need to transcribe numbers of minutes in columns of hours and minutes, without using the formatting functions of Excel. The idea is to understand the principle in order to develop it on other larger scale problems.
I have my table with the numbers of minutes, then the columns requested. What are the formulas that can be implemented, especially for the passage from 59 minutes (0:59) to 60 minutes (1:50)? In image the expected result, but with the values entered manually.
Here a sample:
| Number of minutes | Hour | Minute |
|---|---|---|
| 0 | 0 | 0 |
| 1 | 0 | 1 |
| 59 | 0 | 59 |
| 60 | 1 | 0 |
| 119 | 1 | 59 |
| 120 | 2 | 0 |
CodePudding user response：
Formula for hours: =INTEGER(A2/60)
For minutes: =A2-(60*B2)