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

As an example, start a new spreadsheet and enter 172 into A1. This represents the number of minutes that a piece of machinery has been running (this figure is manually entered after the user has noted the value by reading the machine’s “Activity Log” which outputs a value in minutes).

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

=INT(A1/60)

As we only want to display whole hours, the INT function is used to return the Integer part of the result (172 / 60 = 2.866667).

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

=MOD(A1,60)

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