# How to get the decimal part of a number in Excel

Use MOD with 1: `=MOD(A2,1)` returns what is after the decimal point, so 7.75 gives 0.75.

**Excel:** `=MOD(A2,1)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B |
| --- | --- |
| Hours worked | Decimal part |
| 7.75 |  |
| 8.5 |  |
| 6.25 |  |
| 9.1 |  |
| 4 |  |

Formula in B2, filled to B6: `=MOD(A2,1)`

Result: 0.75; 0.50; 0.25; 0.10; 0.00

## How it works

MOD returns the remainder of a division, and the remainder of dividing by 1 is the fraction after the whole number. 7.75 divided by 1 leaves 0.75; a whole number like 4 leaves 0. Multiply by 60 to turn a fraction of an hour into minutes.

## Other ways

- `=A2-INT(A2)`: The number minus its whole part; the same for positive numbers.
- `=A2-TRUNC(A2)`: Keeps the minus sign for negative numbers: -2.25 gives -0.25.

## Common mistakes

- For negative numbers MOD is always positive: `=MOD(-2.25,1)` gives 0.75. Use `=A2-TRUNC(A2)` to get -0.25.
- Results can carry tiny binary errors, like 0.0999999999999996 for 9.1. Wrap in `ROUND(…,10)` before comparing.

## Questions

**How do I turn the decimal part into minutes?**

Multiply by 60: `=MOD(A2,1)*60` gives 45 for 7.75 hours.

**How do I get the whole-number part?**

Use `=TRUNC(A2)`, or `=INT(A2)` for positive numbers.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/decimal-part-of-a-number