Minutes into hours and minutes
QUOTIENT gives the whole hours, MOD the minutes left over.
Task:
The call system logs talk time in minutes. In C2:C6 show each agent's time as hours and minutes, such as 2h 15m.
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 MOD
0/4The same formula in the other shapes it takes at work.
- MOD Function
Find remainders using the MOD function.
CoreIntermediate - MOD to pick every n-th item
A remainder of zero marks every fifth, tenth or hundredth row.
Intermediate - Minutes into hours and minutes
QUOTIENT gives the whole hours, MOD the minutes left over.
Intermediate - MOD by 2: odd or even
The remainder after halving tells you which side of the street.
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 | Agent | Minutes | Talk time |
| 2 | Ines | 135 | |
| 3 | Jamal | 59 | |
| 4 | Kirsty | 240 | |
| 5 | Luca | 61 | |
| 6 | Maya | 372 |
What this exercise teachesMay contain the answer
QUOTIENT and MOD are two halves of the same division: how many whole times, and what is left. Together they convert any small unit into a larger one plus a remainder — minutes to hours, days to weeks, units to boxes.