How to convert minutes to hours and minutes
✓ Verified in LibreOffice 25.8.7.3Turn a count of minutes into an H:MM display — 150 minutes shown as 2:30 — for timesheets, call logs, and durations.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =INT(A2/60)&":"&TEXT(MOD(A2,60),"00") | INT(A2/60) is whole hours; MOD(A2,60) is leftover minutes, padded to two digits. Returns text like "2:30". |
| Google Sheets | =INT(A2/60)&":"&TEXT(MOD(A2,60),"00") | Identical. For a real time value you can do math on, use =A2/1440 and format the cell as [h]:mm. |
| LibreOffice Calc | =INT(A2/60)&":"&TEXT(MOD(A2,60),"00") | Identical. |
How it works
The two halves of the answer come from integer division and its remainder: INT(A2/60) gives the whole hours (150 ÷ 60 = 2), and MOD(A2,60) gives the minutes left over (150 mod 60 = 30). Joining them with a colon and padding the minutes to two digits via TEXT(...,"00") produces "2:30" — so a stray 5 minutes shows as "0:05", not "0:5". This version returns TEXT, which is perfect for display but can't be summed; if you need a genuine time value to add up or feed into more math, divide the minutes by 1440 (minutes per day) and format the cell as [h]:mm — the square brackets let the hours run past 24 instead of rolling over. Going the other way, multiply an H:MM time by 1440 to get back to total minutes.
Verified, not just documented
We ran =INT(150/60)&":"&TEXT(MOD(150,60),"00") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 2:30 — exactly the expected result. Every formula here is confirmed by actually executing it.
Functions used
INT · TEXT · MOD — see full Excel, Google Sheets & LibreOffice compatibility for each.
Related recipes
- How to count weeks and days between two dates
- How to abbreviate large numbers as K and M
- How to add leading zeros to a number
- How to concatenate a date with text (without getting a number)
- How to convert 12-hour text times to 24-hour