Syntax
MOD(m, n)
Arguments
- m (Number)
- n (Number)
An m or n of a non-Number numeric type may be accepted but may produce unexpected results.
Return Value
Number: the remainder of m divided by n. The result will have the same sign as m.
Examples
MOD([Minutes], 60)
: the number of minutes in excess of the whole hours represented by the Minutes column. Whole hours may be computed with [Minutes] / 60
.
MOD([Hours], 24)
: the number of hours in excess of the whole days represented by the Hours column. Whole days may be computed with [Hours] / 24
.
MOD([Days], 7)
: the number of days in excess of the whole weeks represented by the Days column. Whole weeks may be computed with [Days] / 7
.
MOD(9, 7)
: 2
MOD(-9, 7)
: -2
MOD(9, -7)
: 2
MOD(-9, -7)
: -2
MOD(9, 0)
: 0
MOD(9, 9)
: 0