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.