TIME from a total number of minutes
Put every minute in the minute argument and let TIME sort it out.
Task:
The tracker records each task's duration as a total number of minutes. In C2:C6 show each duration as a time, such as 02:15:00 for 135 minutes.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of TIME
0/3The same formula in the other shapes it takes at work.
- TIME Function
Create time values from hour, minute, and second components.
CoreBeginner - TIME with minute overflow: when does it finish?
Minutes over 59 carry into the hour automatically.
Intermediate - TIME from a total number of minutes
Put every minute in the minute argument and let TIME sort it out.
Beginner
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Task | Minutes | Duration |
| 2 | Design | 135 | |
| 3 | Review | 45 | |
| 4 | Build | 380 | |
| 5 | Test | 90 | |
| 6 | Deploy | 15 |
What this exercise teachesMay contain the answer
The same overflow rule that carries 90 minutes into an hour also converts any total: 380 minutes becomes 06:20:00. TIME wraps at 24 hours, so this works for durations under a day.