TIME with minute overflow: when does it finish?
Minutes over 59 carry into the hour automatically.
Task:
Each appointment starts at the time shown and lasts the number of minutes in D. In E2:E6 give the finishing time.
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 | D | E | |
|---|---|---|---|---|---|
| 1 | Client | Hour | Minute | Duration (min) | Finishes |
| 2 | Avery | 9 | 15 | 50 | |
| 3 | Blake | 10 | 40 | 35 | |
| 4 | Casey | 13 | 0 | 90 | |
| 5 | Drew | 15 | 45 | 20 | |
| 6 | Ellis | 16 | 30 | 150 |
What this exercise teachesMay contain the answer
10:40 plus 35 minutes is 75 minutes past ten, which TIME turns into 11:15 without any division. Letting TIME normalise is simpler and safer than splitting the sum into hours and minutes yourself.