hello all, can i use just 1 formula to return my request if i want to calculate how many staffs will work before 13:00 / after 13:00?
PS:
use M=Morning on before 13:00
use N=Night on after 13:00
if cell blank, no return, no count
=IF((LEFT(A2,5)<"13:00"),"M","N")
=COUNTIF(B2:B6,"M")
<tbody>
</tbody>
<tbody>
</tbody>
thanks,
kelvin
PS:
use M=Morning on before 13:00
use N=Night on after 13:00
if cell blank, no return, no count
=IF((LEFT(A2,5)<"13:00"),"M","N")
=COUNTIF(B2:B6,"M")
time | before / after 13:00 |
14:15 - 22:45 | N |
10:00 - 19:30 | M |
13:00 - 20:30 | N |
15:30 - 22:45 | N |
<tbody>
</tbody>
M | 1 |
N | 3 |
<tbody>
</tbody>
thanks,
kelvin