I am getting an error while counting the timestamp between
06:00 to 17:59 and 18:00 to 05:59 (like morning and night shift report)
am using like
got the correct answer
COUNTIFS($A:$A,$E$3,$B:$B,">=06:00",$B:$B,"<=17:59")
COUNTIFS($A:$A,$E$4,$B:$B,">=06:00",$B:$B,"<=17:59")
its showing error
COUNTIFS($A:$A,$E$3,$B:$B,">=18:00",$B:$B,"<=05:59")
COUNTIFS($A:$A,$E$4,$B:$B,">=18:00",$B:$B,"<=05:59")
I've attached the sample Doc for reference,Kindly do a needful.
Thanks!
06:00 to 17:59 and 18:00 to 05:59 (like morning and night shift report)
am using like
got the correct answer
COUNTIFS($A:$A,$E$3,$B:$B,">=06:00",$B:$B,"<=17:59")
COUNTIFS($A:$A,$E$4,$B:$B,">=06:00",$B:$B,"<=17:59")
its showing error
COUNTIFS($A:$A,$E$3,$B:$B,">=18:00",$B:$B,"<=05:59")
COUNTIFS($A:$A,$E$4,$B:$B,">=18:00",$B:$B,"<=05:59")
I've attached the sample Doc for reference,Kindly do a needful.
Thanks!