On Monday, 14 August 2017 17:31:44 UTC+5:30, Claus Busch wrote:
Hi Max,
Am Mon, 14 Aug 2017 00:09:40 -0700 (PDT) schrieb Max:
Also For Full Month I want to Count Number of 'In_Time' and 'Out_Time' is After and Before the Specific Time. As a Example Total 5 Late In_Time Punch and 3 Early Out Punch in a Month
have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgaFO3KiEebzl6vw69w
If your layout is another one, please provide a demo workbook.
Regards
Claus B.
--
Windows10
Office 2016
WOW, Great....Claus, Thanks you made the solution.. Though I need to learn on the Sum Product Function as well as MOD Function..... As I am not clear that why divisor is 3... If you can Explain.