Explanation

Times in Excel are fractional values of the number 1.

So, 12 PM is 12/24 = .5, 6:00 AM is 6/24 = .25, and so on.

greater than 24 hours).

Excel formula: Extract date from a date and time

Even better, if we end up with a negative fractional value, MOD returns the reciprocal.

So, if we end up with -.25, MOD returns .75 (equivalent to 6 PM).

This is important, because Excel won’t display negative time values.

Excel formula: Extract time from a date and time

These values include both a serial number to represent the date, plus a fractional value to represent time.

For example, MOD(10,3) = 1.

The result of MOD carries the same sign as the divisor.

Excel formula: Calculate hours between two times

Excel MOD function