Explanation
Excel handlesdatesandtimesusing a system in which dates are serial numbers and times are fractional values.
In other words, the time value in a “datetime” is the decimal.
The MOD function returns the remainder from division.
The first argument is the number and the second is the divisor.
For example, MOD(10,3) = 1.
The result of MOD carries the same sign as the divisor.
