Returns the remainder of
dividend divided by divisor (
Number value). The result will have the same sign as dividend.
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
Numberfor which you want to find the remainder.
Numberby which you want to divide the number.
Number numeric type may be accepted for either argument, but may produce unexpected results.