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:
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:
In other words, 172 divided by 60 is 2 remainder 52