Returns the remainder of
m divided by
Number value). The result will have the same sign as
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) returns 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) returns 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) returns
MOD(-9, 7) returns
MOD(9, -7) returns
MOD(-9, -7) returns
MOD(9, 0) returns
MOD(9, 9) returns
m or n of a non-
Number numeric type may be accepted but may produce unexpected results.