Excel Forum
Similar Content
PMT Function - Get the Payment Due for a Loan in Excel
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
MOD Function in Excel
Tutorial: The MOD function is very simple but it can be used to do wonderful things in Excel. It ret...



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.