Excel Forum
Similar Content
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
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 298: MOD function Formula for Total Time Worked

See how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when Time In and Time Out are entered as Time Values.

Got a Question? Ask it Here in the Forum.