The INT, MOD guide
=INT(130/60) is 2, the whole hours in 130 minutes, and =MOD(130, 60) is 10, the minutes left over. Together they split any amount into whole units and a remainder.
The syntax
=INT(number)
=MOD(number, divisor)
INT drops the decimals and rounds down to a whole number. MOD divides and returns what is left over. The order in MOD matters: the number first, then what you divide by. MOD(130, 60) is 10; MOD(60, 130) is 60.
Minutes to hours and minutes
| Minutes | ÷ 60 | INT | MOD(…, 60) |
|---|---|---|---|
| 130 | 2.17 | 2 | 10 |
| 45 | 0.75 | 0 | 45 |
| 120 | 2 | 2 | 0 |
The decimals of 2.17 hours are not 17 minutes: an hour has 60 minutes, not 100. That is why the leftover comes from MOD, not from the decimals.
A label
=C2&" h "&D2&" min" joins the two numbers and the words into "2 h 10 min". The spaces go inside the quotes.
To keep a real time instead of text, divide minutes by 1440 (the minutes in a day) and format the cell as [h]:mm: 130 minutes shows as 2:10.
Other uses
- Items into full boxes and loose items:
INT(B2/24)andMOD(B2, 24). - Every other row:
MOD(ROW(), 2) = 0is TRUE on even rows. - The time part of a date with a time:
MOD(A2, 1).
Negative numbers
INT rounds down the number line, so INT(-2.5) is -3; TRUNC(-2.5) cuts the decimals off and gives -2. QUOTIENT(130, 60) also returns the whole part, 2, and goes toward zero like TRUNC. MOD's result takes the sign of the divisor: MOD(-3, 2) is 1.
Common mistakes
- ROUND for the hours. 45 minutes rounds to 1 hour.
- MOD the wrong way round.
MOD(60, B2)divides 60 by the minutes. - Decimals as minutes. 2.17 hours is 2 h 10 min.
FAQ
- What does MOD do in Excel?
- MOD(number, divisor) returns the remainder after dividing. MOD(130,60) is 10, because 130 is two 60s and 10 left over.
- How do I convert minutes to hours and minutes in Excel?
- Whole hours: =INT(A2/60). Minutes left: =MOD(A2,60). Or divide by 1440 and format the cell as [h]:mm.
- What is the difference between INT and TRUNC?
- For positive numbers they are the same. For negative numbers INT rounds down (INT(-2.5) is -3) and TRUNC cuts off the decimals (TRUNC(-2.5) is -2).
- Why does MOD give the wrong answer?
- Usually the arguments are swapped. The number to divide comes first, the divisor second.



































































