Excel Forum

Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

See how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM. See how to use the MOD function and learn the algorithm that MOD uses to calculate. See how to deal with negative Time.

This is an important Time Math / Payroll / Time Sheet Excel solution. It solves the Night Shift time problems in Excel Time Formulas.

Got a Question? Ask it Here in the Forum.