INT
Drops the fractional part and leaves a whole number: full hours out of minutes, whole units out of a fractional result.
INT(number)- number
- A number or a formula whose whole part you need, for example B2/60.
Return value
A whole number rounded down to the nearest smaller one: 3.9 becomes 3, and −3.2 becomes −4.
Examples
Full hours out of minutes
fx
A
B
C
D
1
2
3
4
5
6
7
Task
Minutes
Full hours
Report
135
Call
50
Invoice check
245
Training
180
Sheet1
Details
INT rounds a number down to the nearest whole number: 3.9 becomes 3. It takes a single argument, so there’s no number of digits to specify.
With negative numbers, “down” means toward the smaller value: −2.3 becomes −3. If you just want to cut the fraction off a negative number, use ROUNDDOWN with 0.
Common mistakes
- INT doesn’t round by the school rule: 3.9 becomes 3, not 4. For normal rounding, use ROUND.
- Negative numbers: =INT(-2.3) gives −3, not −2.