Count of time (attendance)
On Sunday, 10 September 2017 00:24:10 UTC+5:30, Claus Busch wrote:
Hi again,
Am Sat, 9 Sep 2017 20:49:55 +0200 schrieb Claus Busch:
try:
=SUMPRODUCT(--(MOD(COLUMN(E5:BL5),3)=2),--(E5:BL5<""),--(E5:BL5TIME(10,,)))
and
=SUMPRODUCT(--(MOD(COLUMN(E5:BL5),3)=2),--(E5:BL5<""),--(E5:BL5<TIME(18,,)))
sorry, the second formula in the first answer is wrong.
Try:
=SUMPRODUCT(--(MOD(COLUMN(E5:BL5),3)=2),--(E5:BL5<""),--(E5:BL5TIME(10,,)))
and
=SUMPRODUCT(--(MOD(COLUMN(F5:BL5),3)=0),--(F5:BL5<""),--(F5:BL5<TIME(18,,)))
Regards
Claus B.
--
Windows10
Office 2016
Claus... I am Still Using your work out done for me.... Really Appreciates your Prompt help in this forum
|