Call Report Need to count cells a range of times

mr_ITtoyou · Jul 8, 2021

I am having issues setting up a formula to count cells of a range of times, under column (Queue Time) E2. Example first cell count for time range 0:00:00-0:20:59 total, second cell count for time range 0:21:00-0:39:59 total. I set up the cell count beyond the amount of data because the total amount calls are not the same month to month. I am getting a total of 3088 when the count of cells with time 0:00:00-0:20:59 total is 2929.

Master RSA Call Report (002).xlsx

A

B

C

D

E

F

G

H

1

Call Start Time

Call End Time

Application Name

CSQ Names

Queue Time

Agent Name

Talk Time

2

6/1/2021 13:43

6/1/2021 13:56

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:01

Gloria Gutierrez Herrera

0:13:05

3

6/17/2021 14:12

6/17/2021 14:23

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:01

Gloria Gutierrez Herrera

0:08:34

4

6/21/2021 13:21

6/21/2021 13:27

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:01

Traci Mizer

0:05:37

Total less than 00:21:00 = 3088

5

6/30/2021 14:40

6/30/2021 14:45

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:01

Traci Mizer

0:03:58

Total greater than 00:21:00, less than 00:40:00 = 3088

6

6/2/2021 10:57

6/2/2021 11:01

SARH_Physicians_CSQ

Physicians_CSQ*

0:00:02

Traci Mizer

0:03:36

7

6/2/2021 14:27

6/2/2021 14:34

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Ingrid Claros

0:04:19

8

6/9/2021 10:46

6/9/2021 11:14

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:14:37

9

6/11/2021 10:47

6/11/2021 10:55

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:05:00

10

6/11/2021 15:46

6/11/2021 15:59

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:10:54

11

6/11/2021 16:12

6/11/2021 16:21

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:08:14

12

6/14/2021 11:16

6/14/2021 11:19

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:02:11

13

6/14/2021 11:25

6/14/2021 11:26

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:00:44

14

6/14/2021 12:30

6/14/2021 12:39

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:08:30

15

6/14/2021 15:34

6/14/2021 15:42

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:09

16

6/16/2021 9:44

6/16/2021 9:52

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:06:07

17

6/16/2021 10:12

6/16/2021 10:15

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:02:34

18

6/16/2021 12:43

6/16/2021 13:00

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:11:55

19

6/16/2021 16:36

6/16/2021 16:38

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Traci Mizer

0:00:26

20

6/16/2021 16:39

6/16/2021 16:48

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Traci Mizer

0:07:58

21

6/17/2021 11:43

6/17/2021 11:53

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:06:45

22

6/17/2021 14:34

6/17/2021 14:35

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:00:21

23

6/17/2021 14:35

6/17/2021 14:44

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:13

24

6/18/2021 9:14

6/18/2021 9:15

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:00:40

25

6/18/2021 9:15

6/18/2021 9:30

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:07:46

26

6/18/2021 10:41

6/18/2021 10:59

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:09:18

27

6/18/2021 15:52

6/18/2021 16:04

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:09:27

28

6/18/2021 15:55

6/18/2021 15:58

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:02:55

29

6/21/2021 10:29

6/21/2021 10:55

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:19:44

30

6/21/2021 11:15

6/21/2021 11:16

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:00:55

31

6/21/2021 13:19

6/21/2021 13:24

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:03:55

32

6/21/2021 13:40

6/21/2021 13:54

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:14:38

33

6/22/2021 9:13

6/22/2021 9:23

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:09:28

34

6/22/2021 10:23

SARH_Scheduling_CSQ

Mammography_CSQ

0:00:02

Sylvia Rios

0:00:00

35

6/22/2021 15:38

6/22/2021 15:40

SARH_Physicians_CSQ

Physicians_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:01:23

36

6/23/2021 9:29

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:00:01

37

6/23/2021 9:42

6/23/2021 9:53

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:08:10

38

6/23/2021 10:47

6/23/2021 11:00

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:10:16

39

6/23/2021 14:59

6/23/2021 15:07

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:46

40

6/23/2021 15:52

6/23/2021 16:05

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:11:05

41

6/23/2021 16:07

6/23/2021 16:15

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:07:46

42

6/24/2021 8:52

6/24/2021 8:55

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:03:05

43

6/24/2021 9:25

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:00:07

44

6/24/2021 10:35

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:00:20

45

6/24/2021 11:13

6/24/2021 11:24

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:07:05

46

6/24/2021 11:18

6/24/2021 11:26

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Traci Mizer

0:07:27

47

6/25/2021 9:16

6/25/2021 9:25

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:28

48

6/25/2021 9:25

6/25/2021 9:29

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:02:11

49

6/25/2021 10:08

6/25/2021 10:15

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:29

50

6/25/2021 11:52

6/25/2021 12:00

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Sylvia Rios

0:04:17

51

6/25/2021 14:44

6/25/2021 14:50

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:03:18

52

6/28/2021 9:30

6/28/2021 9:34

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:03:10

53

6/28/2021 13:37

6/28/2021 13:39

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:01:28

54

6/29/2021 9:29

6/29/2021 9:31

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:02:24

55

6/29/2021 11:55

6/29/2021 11:56

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:00:38

56

6/29/2021 13:45

6/29/2021 13:47

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:00:42

57

6/29/2021 16:51

6/29/2021 16:59

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:02

Gloria Gutierrez Herrera

0:08:46

58

6/30/2021 11:20

6/30/2021 11:33

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Traci Mizer

0:12:38

59

6/30/2021 12:31

6/30/2021 12:42

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Traci Mizer

0:05:13

60

6/30/2021 15:36

6/30/2021 15:39

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:02

Ingrid Claros

0:03:22

61

6/30/2021 15:45

6/30/2021 15:53

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:02

Sylvia Rios

0:05:41

62

6/3/2021 10:23

6/3/2021 10:36

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:03

Cynthia Schuster

0:10:04

63

6/3/2021 12:28

6/3/2021 12:30

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:03

Traci Mizer

0:00:46

64

6/4/2021 14:09

6/4/2021 14:17

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:03

Ingrid Claros

0:04:42

65

6/9/2021 10:38

6/9/2021 10:45

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Sylvia Rios

0:05:05

66

6/9/2021 14:18

6/9/2021 14:25

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:05:09

67

6/10/2021 9:18

6/10/2021 9:25

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:05:45

68

6/10/2021 11:08

6/10/2021 11:09

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Sylvia Rios

0:00:19

69

6/11/2021 9:12

6/11/2021 9:14

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Ingrid Claros

0:02:22

70

6/11/2021 10:44

6/11/2021 10:56

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Sylvia Rios

0:09:22

71

6/11/2021 15:02

6/11/2021 15:05

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Sylvia Rios

0:02:22

72

6/11/2021 15:10

6/11/2021 15:13

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:03

Sylvia Rios

0:00:57

73

6/14/2021 9:01

6/14/2021 9:03

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:01:31

74

6/14/2021 9:12

6/14/2021 9:30

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:14:15

75

6/14/2021 10:50

6/14/2021 10:56

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:02:42

76

6/14/2021 13:58

6/14/2021 14:16

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:03

Sylvia Rios

0:13:30

77

6/15/2021 16:05

6/15/2021 16:06

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:03

Gloria Gutierrez Herrera

0:00:59

RSA Wait Time_Agent handled

Cell Formulas
Range	Formula
H4	H4	=COUNT(E2:E4000,"<0:21:00")
H5	H5	=COUNT(E2:E4000,"<0:21:00, >0:41:00")

igold · Jul 8, 2021

Can you provide the format for Column E. No matter what I try, everything after Cell E2 displays an hour. For example: Cell E2 = 1:00:01

Sorry that should be Cell E3 shows 1:00:01

mr_ITtoyou · Jul 8, 2021

igold said:
Can you provide the format for Column E. No matter what I try, everything after Cell E2 displays an hour. For example: Cell E2 = 1:00:01

Sorry that should be Cell E3 shows 1:00:01

Here is the format for Column E, custom- h:mm:ss

mr_ITtoyou · Jul 8, 2021

mr_ITtoyou said:
Here is the format for Column E, custom- h:mm:ss
View attachment 42493

If it would work better or easier in a different format, that can change. Thanks for your help.

igold · Jul 8, 2021

When I use that format this is what I get

Two Dudes.xlsm

A

B

C

D

E

F

G

1

Call Start Time

Call End Time

Application Name

CSQ Names

Queue Time

Agent Name

Talk Time

2

44348.57177

44348.58095

SARH_Scheduling_CSQ

Radiology_CSQ*

0:00:01

Gloria Gutierrez Herrera

0.009085648

3

44364.5917

44364.59939

SARH_Scheduling_CSQ

Radiology_CSQ*

1:00:01

Gloria Gutierrez Herrera

0.005949074

4

44368.55648

44368.56052

SARH_Scheduling_CSQ

Radiology_CSQ*

2:00:01

Traci Mizer

0.003900463

5

44377.61174

44377.61494

SARH_Scheduling_CSQ

Radiology_CSQ*

3:00:01

Traci Mizer

0.00275463

6

44349.45662

44349.45924

SARH_Physicians_CSQ

Physicians_CSQ*

4:00:01

Traci Mizer

0.0025

7

44349.60226

44349.60694

SARH_Scheduling_CSQ

Mammography_CSQ*

5:00:01

Ingrid Claros

0.002997685

8

44356.44929

44356.46815

SARH_Scheduling_CSQ

Mammography_CSQ*

6:00:01

Sylvia Rios

0.010150463

9

44358.44993

44358.45503

SARH_Scheduling_CSQ

Radiology_CSQ*

7:00:01

Ingrid Claros

0.003472222

10

44358.65763

44358.66633

SARH_Scheduling_CSQ

Mammography_CSQ*

8:00:01

Sylvia Rios

0.007569444

11

44358.67564

44358.68146

SARH_Scheduling_CSQ

Radiology_CSQ*

9:00:01

Gloria Gutierrez Herrera

0.005717593

12

44361.46962

44361.47159

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

10:00:01

Sylvia Rios

0.001516204

13

44361.47576

44361.47679

SARH_Scheduling_CSQ

Mammography_CSQ*

11:00:01

Sylvia Rios

0.000509259

14

44361.52112

44361.52713

SARH_Scheduling_CSQ

Radiology_CSQ*

12:00:01

Gloria Gutierrez Herrera

0.005902778

15

44361.64869

44361.65461

SARH_Scheduling_CSQ

Mammography_CSQ*

13:00:01

Sylvia Rios

0.003576389

16

44363.40622

44363.4113

SARH_Scheduling_CSQ

Mammography_CSQ*

14:00:01

Sylvia Rios

0.004247685

17

44363.42539

44363.42764

SARH_Scheduling_CSQ

Mammography_CSQ*

15:00:01

Sylvia Rios

0.001782407

18

44363.5301

44363.54189

SARH_Scheduling_CSQ

Radiology_CSQ*

16:00:01

Ingrid Claros

0.008275463

19

44363.69233

44363.69309

SARH_Scheduling_CSQ

Radiology_CSQ*

17:00:01

Traci Mizer

0.000300926

20

44363.69389

44363.70038

SARH_Scheduling_CSQ

Radiology_CSQ*

18:00:01

Traci Mizer

0.005532407

21

44364.48888

44364.49551

SARH_Scheduling_CSQ

Mammography_CSQ*

19:00:01

Sylvia Rios

0.0046875

22

44364.60713

44364.60782

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

20:00:01

Sylvia Rios

0.000243056

23

44364.60804

44364.61424

SARH_Scheduling_CSQ

Mammography_CSQ*

21:00:01

Sylvia Rios

0.003622685

24

44365.38497

44365.38559

SARH_Scheduling_CSQ

Radiology_CSQ*

22:00:01

Ingrid Claros

0.000462963

25

44365.386

44365.39612

SARH_Scheduling_CSQ

Mammography_CSQ*

23:00:01

Sylvia Rios

0.005393519

26

44365.44523

44365.45772

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:01

Sylvia Rios

0.006458333

27

44365.66131

44365.66947

SARH_Scheduling_CSQ

Radiology_CSQ*

1:00:01

Ingrid Claros

0.0065625

28

44365.66338

44365.66586

SARH_Scheduling_CSQ

Mammography_CSQ*

2:00:01

Sylvia Rios

0.002025463

29

44368.43713

44368.45501

SARH_Scheduling_CSQ

Mammography_CSQ*

3:00:01

Sylvia Rios

0.013703704

30

44368.46895

44368.46976

SARH_Scheduling_CSQ

Radiology_CSQ*

4:00:01

Gloria Gutierrez Herrera

0.000636574

31

44368.55546

44368.55837

SARH_Scheduling_CSQ

Mammography_CSQ*

5:00:01

Sylvia Rios

0.002719907

32

44368.5695

44368.5798

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

6:00:01

Sylvia Rios

0.010162037

33

44369.38439

44369.39106

SARH_Scheduling_CSQ

Radiology_CSQ*

7:00:01

Gloria Gutierrez Herrera

0.006574074

34

44369.43281

44369.43297

SARH_Scheduling_CSQ

Mammography_CSQ

8:00:01

Sylvia Rios

0

35

44369.65175

44369.65315

SARH_Physicians_CSQ

Physicians_CSQ*

9:00:01

Gloria Gutierrez Herrera

0.000960648

36

44370.39525

44370.39545

SARH_Scheduling_CSQ

Radiology_CSQ*

10:00:01

Ingrid Claros

1.15741E-05

37

44370.40418

44370.41186

SARH_Scheduling_CSQ

Mammography_CSQ*

11:00:01

Sylvia Rios

0.005671296

38

44370.44943

44370.45844

SARH_Scheduling_CSQ

Mammography_CSQ*

12:00:01

Sylvia Rios

0.00712963

39

44370.62471

44370.63007

SARH_Scheduling_CSQ

Mammography_CSQ*

13:00:01

Sylvia Rios

0.00400463

40

44370.66146

44370.6708

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

14:00:01

Sylvia Rios

0.007696759

41

44370.67174

44370.67723

SARH_Scheduling_CSQ

Radiology_CSQ*

15:00:01

Gloria Gutierrez Herrera

0.005393519

42

44371.36971

44371.37201

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

16:00:01

Sylvia Rios

0.002141204

43

44371.39275

44371.39295

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

17:00:01

Sylvia Rios

8.10185E-05

44

44371.44118

44371.44156

SARH_Scheduling_CSQ

Radiology_CSQ*

18:00:01

Ingrid Claros

0.000231481

45

44371.46779

44371.47509

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

19:00:01

Sylvia Rios

0.004918981

46

44371.47146

44371.47688

SARH_Scheduling_CSQ

Radiology_CSQ*

20:00:01

Traci Mizer

0.005173611

47

44372.38679

44372.39238

SARH_Scheduling_CSQ

Mammography_CSQ*

21:00:01

Sylvia Rios

0.003796296

48

44372.39269

44372.39543

SARH_Scheduling_CSQ

Radiology_CSQ*

22:00:01

Ingrid Claros

0.001516204

49

44372.4224

44372.42762

SARH_Scheduling_CSQ

Mammography_CSQ*

23:00:01

Sylvia Rios

0.00380787

50

44372.49475

44372.50007

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:00:01

Sylvia Rios

0.002974537

51

44372.61439

44372.61817

SARH_Scheduling_CSQ

Mammography_CSQ*

1:00:01

Sylvia Rios

0.002291667

52

44375.39586

44375.39899

SARH_Scheduling_CSQ

Mammography_CSQ*

2:00:01

Sylvia Rios

0.002199074

53

44375.56753

44375.56902

SARH_Scheduling_CSQ

Mammography_CSQ*

3:00:01

Sylvia Rios

0.001018519

54

44376.39544

44376.39721

SARH_Scheduling_CSQ

Radiology_CSQ*

4:00:01

Ingrid Claros

0.001666667

55

44376.49656

44376.49745

SARH_Scheduling_CSQ

Radiology_CSQ*

5:00:01

Ingrid Claros

0.000439815

56

44376.57354

44376.57449

SARH_Scheduling_CSQ

Radiology_CSQ*

6:00:01

Ingrid Claros

0.000486111

57

44376.70213

44376.70832

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

7:00:01

Gloria Gutierrez Herrera

0.006087963

58

44377.47243

44377.48137

SARH_Scheduling_CSQ

Mammography_CSQ*

8:00:01

Traci Mizer

0.008773148

59

44377.52201

44377.52927

SARH_Scheduling_CSQ

Radiology_CSQ*

9:00:01

Traci Mizer

0.003622685

60

44377.65027

44377.65272

SARH_Scheduling_CSQ

Radiology_CSQ*

10:00:01

Ingrid Claros

0.002337963

61

44377.65668

44377.66197

SARH_Scheduling_CSQ

Mammography_CSQ*

11:00:01

Sylvia Rios

0.003946759

62

44350.43278

44350.44203

SARH_Scheduling_CSQ

Radiology_CSQ*

12:00:01

Cynthia Schuster

0.006990741

63

44350.51993

44350.52093

SARH_Scheduling_CSQ

Radiology_CSQ*

13:00:01

Traci Mizer

0.000532407

64

44351.5901

44351.59549

SARH_Scheduling_CSQ

Radiology_CSQ*

14:00:01

Ingrid Claros

0.003263889

65

44356.44367

44356.44809

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

15:00:01

Sylvia Rios

0.003530093

66

44356.59589

44356.60093

SARH_Scheduling_CSQ

Mammography_CSQ*

16:00:01

Sylvia Rios

0.003576389

67

44357.38795

44357.39258

SARH_Scheduling_CSQ

Mammography_CSQ*

17:00:01

Sylvia Rios

0.003993056

68

44357.46448

44357.46523

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

18:00:01

Sylvia Rios

0.000219907

69

44358.3835

44358.38535

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

19:00:01

Ingrid Claros

0.001643519

70

44358.44771

44358.45556

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

20:00:01

Sylvia Rios

0.00650463

71

44358.62701

44358.62914

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

21:00:01

Sylvia Rios

0.001643519

72

44358.63223

44358.63407

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

22:00:01

Sylvia Rios

0.000659722

73

44361.37617

44361.37769

SARH_Scheduling_CSQ

Mammography_CSQ*

23:00:01

Sylvia Rios

0.001053241

74

44361.38334

44361.39627

SARH_Scheduling_CSQ

Mammography_CSQ*

0:00:01

Sylvia Rios

0.009895833

75

44361.45149

44361.45603

SARH_Scheduling_CSQ

Mammography_CSQ*

1:00:01

Sylvia Rios

0.001875

76

44361.58243

44361.59499

SARH_Scheduling_CSQ

Mammography_CSQ*

2:00:01

Sylvia Rios

0.009375

77

44362.67067

44362.67152

SARH_Scheduling_CSQ

Radiology_CSQ*

3:00:01

Gloria Gutierrez Herrera

0.00068287

Sheet4

igold · Jul 8, 2021

I was too slow on an edit. As you can see that did not work for me. However I used the ALT + Click method of copying with XL2BB and was able to download your sheet with your formatting.

igold · Jul 9, 2021

How about this:

Cell H4

Excel Formula:

=COUNTIF(E2:E4000,"<0:21:00")

Cell H5

Excel Formula:

=COUNTIF(E2:E4000,"<0:21:00")+COUNTIF(E2:E4000,">0:41:00")

mr_ITtoyou · Jul 9, 2021

igold said:
How about this:

Cell H4

Excel Formula:

=COUNTIF(E2:E4000,"<0:21:00")

Cell H5

Excel Formula:

=COUNTIF(E2:E4000,"<0:21:00")+COUNTIF(E2:E4000,">0:41:00")

igold, thank you for your assistance on this. The formula Cell H4 worked, had the correct count total of cells with 0:00:00-0:20:00 but the formula cell H5 provided the wrong total. cells that have a time with 0:21:00-0:40:00 provided a total of 2920, there are a total of 147 cells with a time from 00:20:01-00:40:00. I changed the greater than and the less than symbol if that would change the resault but that did not work. I posted a few cells that has the time with 00:20:01-00:40:00.

Master RSA Call Report For The Year.xlsx

A

B

C

D

E

F

G

2931

6/4/2021 8:33

6/4/2021 8:59

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:01

Traci Mizer

0:02:30

2932

6/3/2021 14:55

6/3/2021 15:17

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:03

Gloria Gutierrez Herrera

0:01:12

2933

6/9/2021 12:50

6/9/2021 13:21

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:06

Gloria Gutierrez Herrera

0:09:50

2934

6/10/2021 15:02

6/10/2021 15:23

SARH_Scheduling_CSQ

Radiology_CSQ

0:21:06

Traci Mizer

0:00:00

2935

6/16/2021 13:56

6/16/2021 14:26

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:06

Gloria Gutierrez Herrera

0:06:06

2936

6/3/2021 14:53

6/3/2021 15:16

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:08

Traci Mizer

0:01:30

2937

6/21/2021 14:36

6/21/2021 14:59

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:09

Traci Mizer

0:01:17

2938

6/2/2021 16:36

6/2/2021 17:02

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:13

Traci Mizer

0:04:21

2939

6/2/2021 16:36

6/2/2021 17:02

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:13

Gloria Gutierrez Herrera

0:00:00

2940

6/11/2021 12:13

6/11/2021 12:35

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:14

Gloria Gutierrez Herrera

0:00:47

2941

6/4/2021 11:14

6/4/2021 11:36

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:15

Traci Mizer

0:00:50

2942

6/3/2021 14:35

6/3/2021 15:05

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:16

Traci Mizer

0:05:45

2943

6/4/2021 8:25

6/4/2021 8:47

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:16

Traci Mizer

0:01:01

2944

6/7/2021 11:32

6/7/2021 12:00

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:23

Ingrid Claros

0:06:05

2945

6/21/2021 14:37

6/21/2021 15:07

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:26

Gloria Gutierrez Herrera

0:04:55

2946

6/3/2021 15:02

6/3/2021 15:41

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:27

Traci Mizer

0:02:28

2947

6/16/2021 11:19

6/16/2021 11:44

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:28

Ingrid Claros

0:03:58

2948

6/18/2021 11:45

6/18/2021 12:14

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:28

Gloria Gutierrez Herrera

0:07:13

2949

6/24/2021 14:49

6/24/2021 15:27

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:28

Ingrid Claros

0:15:32

2950

6/28/2021 12:16

6/28/2021 12:38

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:29

Traci Mizer

0:00:47

2951

6/3/2021 13:20

6/3/2021 13:47

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:21:30

Cynthia Schuster

0:05:06

2952

6/18/2021 9:56

6/18/2021 10:41

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:30

Cynthia Schuster

0:18:11

2953

6/9/2021 11:16

6/9/2021 11:45

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:35

Traci Mizer

0:03:12

2954

6/15/2021 11:00

6/15/2021 11:27

SARH_Scheduling_CSQ

Mammography_CSQ*

0:21:36

Gloria Gutierrez Herrera

0:05:29

2955

6/16/2021 11:18

6/16/2021 11:45

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:39

Traci Mizer

0:00:00

2956

6/16/2021 11:18

6/16/2021 11:45

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:39

Gloria Gutierrez Herrera

0:01:13

2957

6/8/2021 12:25

6/8/2021 12:46

SARH_Scheduling_CSQ

Radiology_CSQ

0:21:40

Gloria Gutierrez Herrera

0:00:00

2958

6/14/2021 10:44

6/14/2021 11:07

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:41

Cynthia Schuster

0:01:17

2959

6/15/2021 10:15

6/15/2021 10:37

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:49

Ingrid Claros

0:00:01

2960

6/4/2021 10:58

6/4/2021 11:23

SARH_Scheduling_CSQ

Radiology_Span_CSQ*

0:21:51

Gloria Gutierrez Herrera

0:01:06

2961

6/11/2021 12:13

6/11/2021 12:41

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:53

Gloria Gutierrez Herrera

0:05:14

2962

6/24/2021 14:22

6/24/2021 14:46

SARH_Scheduling_CSQ

Radiology_CSQ*

0:21:54

Gloria Gutierrez Herrera

0:01:47

2963

6/22/2021 13:28

6/22/2021 14:01

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:21:58

Cynthia Schuster

0:09:20

2964

6/3/2021 15:08

6/3/2021 15:32

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:00

Cynthia Schuster

0:00:41

2965

6/3/2021 14:54

6/3/2021 15:24

SARH_Scheduling_CSQ

Mammography_CSQ*

0:22:06

Traci Mizer

0:05:27

2966

6/16/2021 13:54

6/16/2021 14:20

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:11

Traci Mizer

0:03:57

2967

6/2/2021 16:33

6/2/2021 16:57

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:22:15

Gloria Gutierrez Herrera

0:00:53

2968

6/4/2021 8:31

6/4/2021 8:54

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:16

Traci Mizer

0:00:39

2969

6/14/2021 9:35

6/14/2021 9:59

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:17

Gloria Gutierrez Herrera

0:01:22

2970

6/15/2021 10:59

6/15/2021 11:33

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:22:18

Ingrid Claros

0:06:57

2971

6/4/2021 8:33

6/4/2021 9:13

SARH_Scheduling_CSQ

Mammography_CSQ*

0:22:21

Cynthia Schuster

0:12:18

2972

6/23/2021 8:36

6/23/2021 9:07

SARH_Scheduling_CSQ

Radiology_Span_CSQ*

0:22:24

Gloria Gutierrez Herrera

0:08:58

2973

6/8/2021 13:18

6/8/2021 13:48

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:22:26

Ingrid Claros

0:03:32

2974

6/8/2021 12:42

6/8/2021 13:09

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:27

Traci Mizer

0:04:02

2975

6/15/2021 13:22

6/15/2021 13:59

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:27

Ingrid Claros

0:10:22

2976

6/7/2021 11:28

6/7/2021 11:59

SARH_Scheduling_CSQ

Mammography_CSQ*

0:22:37

Cynthia Schuster

0:06:25

2977

6/16/2021 8:14

6/16/2021 8:38

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:45

Ingrid Claros

0:00:03

2978

6/21/2021 8:46

6/21/2021 9:18

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:49

Gloria Gutierrez Herrera

0:09:34

2979

6/3/2021 14:14

6/3/2021 14:48

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:54

Gloria Gutierrez Herrera

0:06:56

2980

6/4/2021 11:07

6/4/2021 11:35

SARH_Scheduling_CSQ

Radiology_CSQ*

0:22:54

Gloria Gutierrez Herrera

0:04:18

2981

6/25/2021 8:44

6/25/2021 9:09

SARH_Scheduling_CSQ

Mammography_CSQ*

0:22:58

Traci Mizer

0:01:10

2982

6/4/2021 9:24

6/4/2021 9:54

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:00

Traci Mizer

0:05:03

2983

6/4/2021 9:24

6/4/2021 9:54

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:00

Cynthia Schuster

0:00:00

2984

6/14/2021 10:35

6/14/2021 11:01

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:00

Traci Mizer

0:03:33

2985

6/10/2021 15:09

6/10/2021 15:43

SARH_Scheduling_CSQ

Mammography_Span_CSQ*

0:23:08

Ingrid Claros

0:08:59

2986

6/9/2021 13:24

6/9/2021 13:49

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:10

Gloria Gutierrez Herrera

0:01:49

2987

6/9/2021 11:05

6/9/2021 11:41

SARH_Scheduling_CSQ

Mammography_CSQ*

0:23:19

Ingrid Claros

0:11:09

2988

6/10/2021 15:05

6/10/2021 15:29

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:21

Traci Mizer

0:00:42

2989

6/10/2021 15:06

6/10/2021 15:34

SARH_Scheduling_CSQ

Mammography_CSQ*

0:23:22

Traci Mizer

0:03:40

2990

6/11/2021 11:50

6/11/2021 12:20

SARH_Scheduling_CSQ

Radiology_Span_CSQ*

0:23:26

Gloria Gutierrez Herrera

0:07:03

2991

6/1/2021 9:13

6/1/2021 9:39

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:40

Cynthia Schuster

0:01:38

2992

6/16/2021 11:22

6/16/2021 11:49

SARH_Scheduling_CSQ

Radiology_CSQ*

0:23:41

Traci Mizer

0:03:50

2993

6/1/2021 9:15

6/1/2021 9:51

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:23:50

Cynthia Schuster

0:09:44

2994

6/3/2021 13:15

6/3/2021 13:45

SARH_Scheduling_CSQ

Radiology_Span_CSQ*

0:23:51

Gloria Gutierrez Herrera

0:05:03

2995

6/4/2021 10:45

6/4/2021 11:20

SARH_Scheduling_CSQ

Mammography_Span_CSQ*

0:23:52

Gloria Gutierrez Herrera

0:10:36

2996

6/1/2021 9:14

6/1/2021 9:42

SARH_Scheduling_CSQ

Mammography_CSQ*

0:23:59

Traci Mizer

0:03:02

2997

6/9/2021 13:25

6/9/2021 14:06

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:05

Gloria Gutierrez Herrera

0:12:15

2998

6/28/2021 16:11

6/28/2021 16:43

SARH_Scheduling_CSQ

Mammography_Span_CSQ*

0:24:07

Gloria Gutierrez Herrera

0:07:50

2999

6/9/2021 11:05

6/9/2021 11:31

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:08

Traci Mizer

0:01:13

3000

6/9/2021 11:27

6/9/2021 11:55

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:13

Traci Mizer

0:03:29

3001

6/4/2021 11:05

6/4/2021 11:30

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:15

Gloria Gutierrez Herrera

0:00:52

3002

6/11/2021 11:59

6/11/2021 12:28

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:24:17

Traci Mizer

0:04:25

3003

6/15/2021 14:25

6/15/2021 15:03

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:24:18

Cynthia Schuster

0:11:28

3004

6/15/2021 13:31

6/15/2021 14:12

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:19

Cynthia Schuster

0:00:00

3005

6/15/2021 13:31

6/15/2021 14:12

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:19

Cynthia Schuster

0:10:11

3006

6/9/2021 11:55

6/9/2021 12:20

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:21

Traci Mizer

0:00:16

3007

6/4/2021 10:43

6/4/2021 11:09

SARH_Scheduling_CSQ

Radiology_Span_CSQ*

0:24:25

Ingrid Claros

0:01:01

3008

6/4/2021 16:04

6/4/2021 16:33

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:27

Traci Mizer

0:04:27

3009

6/9/2021 11:07

6/9/2021 11:37

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:39

Traci Mizer

0:04:42

3010

6/9/2021 10:59

6/9/2021 11:27

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:24:40

Traci Mizer

0:02:33

3011

6/16/2021 13:34

6/16/2021 14:05

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:24:42

Gloria Gutierrez Herrera

0:06:15

3012

6/15/2021 10:30

6/15/2021 10:56

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:45

Ingrid Claros

0:00:37

3013

6/16/2021 8:39

6/16/2021 9:17

SARH_Scheduling_CSQ

Pre_Registration_CSQ*

0:24:48

Sylvia Rios

0:12:30

3014

6/3/2021 14:12

6/3/2021 14:37

SARH_Scheduling_CSQ

Radiology_CSQ*

0:24:57

Gloria Gutierrez Herrera

0:00:13

3015

6/16/2021 10:37

6/16/2021 11:04

SARH_Scheduling_CSQ

Radiology_CSQ*

0:25:11

Gloria Gutierrez Herrera

0:01:03

3016

6/15/2021 14:24

6/15/2021 14:55

SARH_Scheduling_CSQ

Radiology_CSQ*

0:25:12

Traci Mizer

0:03:58

3017

6/3/2021 14:46

6/3/2021 15:19

SARH_Scheduling_CSQ

Radiology_CSQ*

0:25:29

Ingrid Claros

0:07:13

3018

6/10/2021 11:04

6/10/2021 11:35

SARH_Scheduling_CSQ

Radiology_CSQ*

0:25:35

Traci Mizer

0:04:24

3019

6/3/2021 14:11

6/3/2021 14:37

SARH_Scheduling_CSQ

Mammography_CSQ*

0:25:39

Gloria Gutierrez Herrera

0:00:18

3020

6/1/2021 8:57

6/1/2021 9:35

SARH_Scheduling_CSQ

Radiology_CSQ*

0:25:42

Cynthia Schuster

0:09:58

RSA Wait Time_Agent handled

igold · Jul 9, 2021

The way I read your formula that was in your post #1- was that you wanted the sum of the cells that were less than 0:21:00 + the cells that were greater than 0:41:00.

Are you looking for the number cells that are between those two times.

mr_ITtoyou · Jul 9, 2021

igold said:
The way I read your formula that was in your post #1- was that you wanted the sum of the cells that were less than 0:21:00 + the cells that were greater than 0:41:00.

Are you looking for the number cells that are between those two times.

Yes, between the numbers or between times in this case. Sorry for not being clear on that.

Call Report Need to count cells a range of times

mr_ITtoyou

New Member

Excel Facts

igold

Well-known Member

mr_ITtoyou

New Member

mr_ITtoyou

New Member

igold

Well-known Member

igold

Well-known Member

igold

Well-known Member

mr_ITtoyou

New Member

igold

Well-known Member

mr_ITtoyou

New Member

Similar threads

Forum statistics

Share this page

Call Report Need to count cells a range of times

New Member

Excel Facts

Well-known Member

New Member

New Member

Well-known Member

Well-known Member

Well-known Member

New Member

Well-known Member

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock