The MOD function in Excel returns the remainder after a number is divided by a divisor.

As an example, you work in a factory and are in charge of a piece of machinery. You need to know how many hours and minutes the machine has been running. To do this, you check the machine’s Activity Log, which shows the “uptime” as 172 minutes. Your manager requires the information in hours and minutes (i.e. 2 hours, 52 minutes).

Start a new spreadsheet and type 172 into A1

Enter a formula in A2 to calculate the number of whole hours:


172 / 60 is 2.866667 but as we only want to display whole hours we are using the INT function to return just the Integer part of the result, i.e 2

The formula in A3 which calculates the number of remaining minutes is:


In other words, 172 divided by 60 is 2 remainder 52