What it does
INT drops the decimal part, but always rounding down. For positive numbers that is the same as cutting off the decimals (7.9 → 7); for negative numbers it goes to the next whole number below (-7.3 → -8). To cut the decimals and keep the sign, use TRUNC: =TRUNC(-7.3) returns -7.
In Excel a date and time is one number: the whole part is the day and the decimal part is the time. So =INT(A2) returns just the date from a value such as 15 March 2025 14:30, and =A2-INT(A2) returns just the time. Multiply a time by 24 and take INT to get the number of full hours.
For the whole part of a division use =INT(A2/B2) or QUOTIENT; for the remainder use MOD. If you want to round to the nearest whole number, you need ROUND, not INT: =ROUND(7.9,0) returns 8.
Syntax
=INT(number)=TAMSAYI(sayı)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The number, cell or formula to round down. With a date-time value, the time part is dropped. |
Examples
1Find how many full boxes you can pack
The quantity is divided by the units per box, and INT drops the decimals; the leftover is the total minus the units in the full boxes.
=INT(B2/C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Qty | Per Box | Full Boxes | Left Over |
| 2 | Grounded socket | 125 | 12 | 10 | 5 |
| 3 | Circuit breaker | 300 | 25 | 12 | 0 |
| 4 | Light switch | 98 | 10 | 9 | 8 |
| 5 | Cable duct | 61 | 20 | 3 | 1 |
- D2 (filled down to D5)
=INT(B2/C2) - E2 (filled down to E5)
=B2-D2*C2
125 sockets fill 10 full boxes with 5 left over. 300 breakers divide evenly, so nothing is left: 0.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Split a working time into hours and minutes
In Excel a duration is a fraction of a day; multiplied by 24 it becomes hours. INT gives the full hours, and the rest, multiplied by 60 and rounded, gives the minutes.
=INT(B2*24)| A | B | C | D | |
|---|---|---|---|---|
| 1 | Employee | Duration | Full Hours | Minutes |
| 2 | Emma | 07:45 | 7 | 45 |
| 3 | Liam | 08:20 | 8 | 20 |
| 4 | Olivia | 09:50 | 9 | 50 |
| 5 | Noah | 06:10 | 6 | 10 |
- C2 (filled down to C5)
=INT(B2*24) - D2 (filled down to D5)
=ROUND((B2*24-C2)*60,0)
Emma's 07:45 is 7 hours and 45 minutes; Olivia's is 9 hours and 50 minutes.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
3INT and TRUNC with negative numbers
Both functions agree on positive numbers. For negative numbers INT goes down to the next whole number, while TRUNC just cuts off the decimals.
=INT(A2)| A | B | C | |
|---|---|---|---|
| 1 | Value | INT | TRUNC |
| 2 | 7.9 | 7 | 7 |
| 3 | 7.3 | 7 | 7 |
| 4 | -7.3 | -8 | -7 |
| 5 | -7.9 | -8 | -7 |
- B2 (filled down to B5)
=INT(A2) - C2 (filled down to C5)
=TRUNC(A2)
For 7.9 both return 7. For -7.3, INT returns -8 and TRUNC -7.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Unexpected result for negatives
Cause: You expected -7 for -7.3 but got -8; INT always rounds down.
Fix: To just cut off the decimals, use TRUNC.
- One hour short
Cause: The time came from another calculation, and a whole hour such as 8:00 was stored in binary as 7.9999999, so INT returned 7.
Fix: Round to a few decimals first:
=INT(ROUND(B2*24,6)).- #VALUE!
Cause: number is text that cannot be read as a number.
Fix: Make sure the cell really contains a number.
Good to know
- To take only the date from a cell with a date and time, use
=INT(A2)and give the result a date format. - INT can give a rough age in whole years, but for an exact result use DATEDIF.
In Nexell
Get Nexell to do it from a sentence
Add two columns that show how many full boxes each product fills and how many units are left over
Convert to tableBring your stock list into the tool and type this. Nexell builds both columns with real Excel formulas and shows them in the preview first; in the downloaded file, the box count follows any change in quantity.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between INT and TRUNC?
For positive numbers there is none. For negative numbers INT rounds down (-7.3 → -8), while TRUNC just cuts off the decimals (-7.3 → -7).
How do I get just the date from a date and time?
=INT(A2) drops the time; show the result with a date format. To get only the time, use =A2-INT(A2) with a time format.