Get the remainder of a division, or the whole-number part of a value.
Copy this formula
=MOD(A2, B2)MOD returns the remainder after dividing; INT returns the integer part by rounding down. Together they split totals into whole units and leftovers — e.g. minutes into hours and minutes.
=INT(130/60) & "h " & MOD(130,60) & "m"→2h 10mSplits 130 minutes into hours and minutes.
Use MOD on the row number: =MOD(ROW(), 3)=0 is TRUE on every third row.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.