Duration hours:mins Column A | Type of interruption Column B | Number of cust affected Column C | Event day? Y/N Column D |
13:39 | Unplanned | 13 | N |
43.27 | Unplanned | 20 | N |
6:00 | Planned | 80 | N |
<tbody>
</tbody>
Hi,
The above table shows a sample of what I am doing.
I'm trying to count the number of instances that meets the following criteria:
Number of instances where Unplanned interruption occrured during none event day that are: (the formula on right is what I currently have on the table but is not working. It only displays "0". I just want to note that the time column (Column A) is formatted as [h]:mm;@
<8 hours <strike></strike> | =COUNTIFS($A$4:$A$47,"<8:00",$B$4:$B$47,"Unplanned",$D$4:$D$47,"NO") |
>8 hours and <12 hours <strike></strike> | COUNTIFS($A$4:$A$47,">8:00",$A$4:$A$47,"<12:00",$B$4:$B$47,"Unplanned",$D$4:$D$47,"NO")<strike></strike> |
=12 hours <strike></strike> | =COUNTIFS($A$4:$A$47,"=12:00",$B$4:$B$47,"Unplanned",$D$4:$D$47,"NO") |
>12 hours and <=24 hours <strike></strike> | COUNTIFS($A$4:$A$47,">12:00",$A$4:$A$47,"<24:00",$B$4:$B$47,"Unplanned",$D$4:$D$47,"NO") <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike> |
36 to 48 hours <strike></strike> | COUNTIFS($A$4:$A$47,">36:00",$A$4:$A$47,"=48:00",$B$4:$B$47,"Unplanned",$D$4:$D$47,"NO") <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike> |
<tbody>
</tbody>
Thank you.
Jao