Skip to content

Excel function · Math

Excel INT function

INT rounds a number down to the nearest whole number that is less than or equal to it: 7.9 becomes 7. It is used to work out how many full boxes you can pack or how many full hours a duration contains.

In Turkish Excel: TAMSAYI

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

English Excel=INT(number)
Turkish Excel=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

ArgumentRequiredDescription
numberRequiredThe 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.

D2fx=INT(B2/C2)
Find how many full boxes you can pack: example table
ABCDE
1ProductQtyPer BoxFull BoxesLeft Over
2Grounded socket12512105
3Circuit breaker30025120
4Light switch981098
5Cable duct612031
  • 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.

C2fx=INT(B2*24)
Split a working time into hours and minutes: example table
ABCD
1EmployeeDurationFull HoursMinutes
2Emma07:45745
3Liam08:20820
4Olivia09:50950
5Noah06:10610
  • 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.

B2fx=INT(A2)
INT and TRUNC with negative numbers: example table
ABC
1ValueINTTRUNC
27.977
37.377
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

Type this in Nexell

Add two columns that show how many full boxes each product fills and how many units are left over

Convert to table

Bring 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.

Related functions

All math functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free