Ashutoshkumar
New Member
- Joined
- Oct 21, 2016
- Messages
- 5
Hi
I have TL’ name in column “C” and data corresponding to other column as “Actual login hour” in column “J”, “total idle time “ in column “L”, “Total wrap up time” in column “M”, and total training time” in column “Q”.
I want to count TL’s name if red background color in every column depending on background color. If there are 49 agents login and 30 are in red background then count the TL’s name whose corresponding column “J” as per column “C”.
Report format
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I am unable to paste the format actually. there are some cells which are in red background
I need output in count of cell red as respective to TL's name.
Thanks
I have TL’ name in column “C” and data corresponding to other column as “Actual login hour” in column “J”, “total idle time “ in column “L”, “Total wrap up time” in column “M”, and total training time” in column “Q”.
I want to count TL’s name if red background color in every column depending on background color. If there are 49 agents login and 30 are in red background then count the TL’s name whose corresponding column “J” as per column “C”.
Report format
TL NAME | ACTUAL LOG IN DURATION | TOTAL IDLE TIME | TOTAL WRAPUP TIME | TOTAL TRAINING DURATION |
Ekta | 7:44:46 | 1:55:51 | 1:44:44 | 0:05:09 |
Om Prakash | 7:10:37 | 1:55:08 | 2:07:46 | 0:12:52 |
Ekta | 8:11:16 | 2:34:57 | 1:34:12 | 0:00:00 |
Vikas Kumar Giri | 8:07:30 | 1:43:29 | 0:48:01 | 0:04:17 |
Om Prakash | 8:19:09 | 2:24:39 | 1:34:27 | 0:10:54 |
Om Prakash | 8:08:32 | 2:08:42 | 2:55:40 | 0:09:50 |
Vikas Kumar Giri | 8:01:37 | 0:59:10 | 0:45:08 | 0:14:36 |
Vikas Kumar Giri | 8:11:53 | 1:01:21 | 1:27:16 | 0:00:50 |
Ekta | 8:09:19 | 2:35:15 | 1:24:50 | 0:05:29 |
Vikas Kumar Giri | 8:09:24 | 1:25:25 | 1:20:24 | 0:16:58 |
Om Prakash | 8:12:36 | 1:42:50 | 2:31:51 | 0:26:19 |
Vikas Kumar Giri | 8:10:35 | 1:29:38 | 1:00:39 | 0:20:00 |
Om Prakash | 8:26:07 | 2:00:51 | 1:37:26 | 0:16:35 |
Harpreet | 7:56:25 | 1:21:11 | 0:50:38 | 0:41:08 |
Ekta | 6:59:04 | 1:49:19 | 1:05:03 | 0:00:00 |
Veer Bhadra | 8:08:40 | 2:17:54 | 1:42:11 | 0:00:00 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I am unable to paste the format actually. there are some cells which are in red background
I need output in count of cell red as respective to TL's name.
Thanks