Spreadsheet: 761500d1640955976-countifs-formula-not-working-sample
Sheet: Sheet1

Case Number | Case Owner | Date/Time Opened | Opened date | Opened time | Month | Time Taken (min) | Date/Time Closed | Closed date | Closed time | Premium ID | Resolution time (hours) |  |  | Totals cases <= 4 hours
24125541 | Saranya S | 11/2/2021, 10:55 AM | 2021-11-02 00:00:00 | 10:55 AM | 11 | 5.48 | 11/2/2021, 11:00 AM | 2021-11-02 00:00:00 | 11:00 AM | 1838691253 |  |  | Saranya S |  |  | 04:00:00
24150573 | [NAME] Rathore | 11/2/2021, 6:27 PM | 2021-11-02 00:00:00 | 6:27 PM | 11 | 6.15 | 11/2/2021, 6:33 PM | 2021-11-02 00:00:00 | 6:33 PM | 2057601884 |  |  | [NAME] Rathore
24152133 | [NAME] | 11/2/2021, 6:55 PM | 2021-11-02 00:00:00 | 6:55 PM | 11 | 8.37 | 11/2/2021, 7:03 PM | 2021-11-02 00:00:00 | 7:03 PM | 1945501913 |  |  | [NAME]
24153489 | Saranya S | 11/2/2021, 7:19 PM | 2021-11-02 00:00:00 | 7:19 PM | 11 | 13.37 | 11/2/2021, 7:32 PM | 2021-11-02 00:00:00 | 7:32 PM | 1950164776 |  |  | Indhrajith Suresh Kumar
24152492 | Saranya S | 11/2/2021, 7:02 PM | 2021-11-02 00:00:00 | 7:02 PM | 11 | 13.62 | 11/2/2021, 7:15 PM | 2021-11-02 00:00:00 | 7:15 PM | 1800089365 |  |  | [NAME]
24151860 | Indhrajith Suresh Kumar | 11/2/2021, 6:50 PM | 2021-11-02 00:00:00 | 6:50 PM | 11 | 14.02 | 11/2/2021, 7:04 PM | 2021-11-02 00:00:00 | 7:04 PM | 1065503747 |  |  | Syed Tausif
24129369 | [NAME] | 11/2/2021, 11:51 AM | 2021-11-02 00:00:00 | 11:51 AM | 11 | 14.57 | 11/2/2021, 12:06 PM | 2021-11-02 00:00:00 | 12:06 PM | 1006684011 |  |  | [NAME]
24134211 | Indhrajith Suresh Kumar | 11/2/2021, 1:14 PM | 2021-11-02 00:00:00 | 1:14 PM | 11 | 16.55 | 11/2/2021, 1:31 PM | 2021-11-02 00:00:00 | 1:31 PM | 1190408784 |  |  | [NAME]
24136619 | Syed Tausif | 11/2/2021, 2:00 PM | 2021-11-02 00:00:00 | 2:00 PM | 11 | 17.9 | 11/2/2021, 2:18 PM | 2021-11-02 00:00:00 | 2:18 PM | 1709343605 |  |  | [NAME] Vijaya [NAME]
24141746 | Saranya S | 11/2/2021, 3:45 PM | 2021-11-02 00:00:00 | 3:45 PM | 11 | 20.73 | 11/2/2021, 4:06 PM | 2021-11-02 00:00:00 | 4:06 PM | 1147250474 |  |  | Karthik R
24141982 | [NAME] | 11/2/2021, 3:50 PM | 2021-11-02 00:00:00 | 3:50 PM | 11 | 22.37 | 11/2/2021, 4:12 PM | 2021-11-02 00:00:00 | 4:12 PM | 2033626565 |  |  | Reshma Devadiga
24128474 | [NAME] | 11/2/2021, 11:38 AM | 2021-11-02 00:00:00 | 11:38 AM | 11 | 25.27 | 11/2/2021, 12:03 PM | 2021-11-02 00:00:00 | 12:03 PM | 1811949357 |  |  | [NAME]
24144919 | Saranya S | 11/2/2021, 4:44 PM | 2021-11-02 00:00:00 | 4:44 PM | 11 | 29.97 | 11/2/2021, 5:14 PM | 2021-11-02 00:00:00 | 5:14 PM | 2033626565 |  |  | [NAME]
24122066 | Syed Tausif | 11/2/2021, 10:01 AM | 2021-11-02 00:00:00 | 10:01 AM | 11 | 31.33 | 11/2/2021, 10:33 AM | 2021-11-02 00:00:00 | 10:33 AM | 1763987361 |  |  | [NAME]
24153201 | Syed Tausif | 11/2/2021, 7:13 PM | 2021-11-02 00:00:00 | 7:13 PM | 11 | 63.55 | 11/2/2021, 8:17 PM | 2021-11-02 00:00:00 | 8:17 PM | 1977741615 |  |  | [NAME]
24147582 | [NAME] | 11/2/2021, 5:33 PM | 2021-11-02 00:00:00 | 5:33 PM | 11 | 66.63 | 11/2/2021, 6:40 PM | 2021-11-02 00:00:00 | 6:40 PM | 1346694671 |  |  | Avneet Kumar
24150313 | [NAME] Vijaya [NAME] | 11/2/2021, 6:22 PM | 2021-11-02 00:00:00 | 6:22 PM | 11 | 78.7 | 11/2/2021, 7:41 PM | 2021-11-02 00:00:00 | 7:41 PM | 1610797143 |  |  | Pratap R
24140452 | Karthik R | 11/2/2021, 3:19 PM | 2021-11-02 00:00:00 | 3:19 PM | 11 | 80.58 | 11/2/2021, 4:40 PM | 2021-11-02 00:00:00 | 4:40 PM | 1929478646 |  |  | [NAME]
24138080 | Indhrajith Suresh Kumar | 11/2/2021, 2:31 PM | 2021-11-02 00:00:00 | 2:31 PM | 11 | 86.07 | 11/2/2021, 3:57 PM | 2021-11-02 00:00:00 | 3:57 PM | 1825983293 |  |  | [NAME]
24135291 | [NAME] | 11/2/2021, 1:34 PM | 2021-11-02 00:00:00 | 1:34 PM | 11 | 109.63 | 11/2/2021, 3:23 PM | 2021-11-02 00:00:00 | 3:23 PM | 1608901895 |  |  | [NAME]
24127930 | Saranya S | 11/2/2021, 11:29 AM | 2021-11-02 00:00:00 | 11:29 AM | 11 | 117.1 | 11/2/2021, 1:26 PM | 2021-11-02 00:00:00 | 1:26 PM | 1922245026 |  |  | 0
24130471 | [NAME] | 11/2/2021, 12:08 PM | 2021-11-02 00:00:00 | 12:08 PM | 11 | 124.85 | 11/2/2021, 2:13 PM | 2021-11-02 00:00:00 | 2:13 PM | 1825867365
24181025 | Reshma Devadiga | 11/3/2021, 7:09 PM | 2021-11-03 00:00:00 | 7:09 PM | 11 | 60272.53 | 12/15/2021, 3:42 PM | 2021-12-15 00:00:00 | 3:42 PM | 1956747175 | 41 days, 20:32:31.800000
24206580 | [NAME] | 11/5/2021, 5:47 PM | 2021-11-05 00:00:00 | 5:47 PM | 11 | 32773.7 | 11/28/2021, 12:00 PM | 2021-11-28 00:00:00 | 12:00 PM | 1787237068 | 22 days, 18:13:42
25361073 | Reshma Devadiga | 12/7/2021, 10:23 AM | 2021-12-07 00:00:00 | 10:23 AM | 12 | 30613.57 | 12/28/2021, 4:37 PM | 2021-12-28 00:00:00 | 4:37 PM | 1721632876 | 21 days, 6:13:34.200000
24749139 | [NAME] | 11/19/2021, 5:07 PM | 2021-11-19 00:00:00 | 5:07 PM | 11 | 28593.1 | 12/9/2021, 1:40 PM | 2021-12-09 00:00:00 | 1:40 PM | 1901518193 | 19 days, 20:33:06
25700486 | [NAME] | 12/14/2021, 1:23 PM | 2021-12-14 00:00:00 | 1:23 PM | 12 | 23190.98 | 12/30/2021, 3:54 PM | 2021-12-30 00:00:00 | 3:54 PM | 1072906348 | 16 days, 2:30:58.800000
25559953 | [NAME] | 12/9/2021, 7:52 PM | 2021-12-09 00:00:00 | 7:52 PM | 12 | 17306.05 | 12/21/2021, 8:18 PM | 2021-12-21 00:00:00 | 8:18 PM | 1747243838 | 12 days, 0:26:03
24544438 | Avneet Kumar | 11/12/2021, 4:20 PM | 2021-11-12 00:00:00 | 4:20 PM | 11 | 17200.55 | 11/24/2021, 3:00 PM | 2021-11-24 00:00:00 | 3:00 PM | 1854322438 | 11 days, 22:40:33
24936625 | [NAME] | 11/25/2021, 8:42 PM | 2021-11-25 00:00:00 | 8:42 PM | 11 | 16704.57 | 12/7/2021, 11:07 AM | 2021-12-07 00:00:00 | 11:07 AM | 1035916205 | 11 days, 14:24:34.200000
24495395 | Pratap R | 11/11/2021, 10:03 AM | 2021-11-11 00:00:00 | 10:03 AM | 11 | 16284.18 | 11/22/2021, 5:27 PM | 2021-11-22 00:00:00 | 5:27 PM | 1012480564 | 11 days, 7:24:10.800000
25656087 | [NAME] | 12/12/2021, 8:25 PM | 2021-12-12 00:00:00 | 8:25 PM | 12 | 15588.42 | 12/23/2021, 4:14 PM | 2021-12-23 00:00:00 | 4:14 PM | 1058165215 | 10 days, 19:48:25.200000
24278278 | [NAME] | 11/7/2021, 12:46 PM | 2021-11-07 00:00:00 | 12:46 PM | 11 | 13184.55 | 11/16/2021, 4:30 PM | 2021-11-16 00:00:00 | 4:30 PM | 1502415462 | 9 days, 3:44:33
24892826 | [NAME] | 11/24/2021, 5:34 PM | 2021-11-24 00:00:00 | 5:34 PM | 11 | 12958.73 | 12/3/2021, 5:32 PM | 2021-12-03 00:00:00 | 5:32 PM | 1698171231 | 8 days, 23:58:43.800000
25564218 | [NAME] | 12/10/2021, 10:28 AM | 2021-12-10 00:00:00 | 10:28 AM | 12 | 12936.17 | 12/19/2021, 10:04 AM | 2021-12-19 00:00:00 | 10:04 AM | 1766450716 | 8 days, 23:36:10.200000