Excel Forum

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.