Formula to count max employees at any time

[asad]

Hi Guys,

I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual table is much bigger with a lot more employees.

Start	Meal Start	Meal End	Finish	Total	Day
03:33	06:27	07:27	11:44	07:11	Mon,Tue,Wed
03:45	07:30	08:16	12:33	08:02	Mon,Tue,Wed
03:48	07:48	08:37	12:47	08:10	Mon,Tue,Wed
04:03	06:56	07:41	11:58	07:10	Mon,Tue,Wed
04:18	08:30	09:19	12:12	07:05	Mon,Tue,Wed
04:33	08:43	09:33	13:43	08:20	Mon,Tue,Wed
05:03	09:21	10:01	12:59	07:16	Mon,Tue,Wed
05:10	09:28	10:15	13:08	07:11	Mon,Tue,Wed
05:25	09:47	10:43	13:36	07:15	Mon,Tue,Wed
05:40	10:25	11:25	14:18	07:38	Mon,Tue,Wed
05:55	10:10	11:04	14:02	07:13	Mon,Tue,Wed
06:03	10:53	11:53	16:07	09:04	Mon,Tue,Wed
06:33	11:14	12:14	16:33	09:00	Mon,Tue,Wed
08:18	11:28	12:28	16:42	07:24	Mon,Tue,Wed
08:20	12:38	13:38	18:01	08:41	Mon,Tue,Wed
08:50	13:13	14:13	18:43	08:53	Mon,Tue,Wed
09:07	12:17	13:17	17:40	07:33	Mon,Tue,Wed
11:34	14:27	15:23	19:49	07:19	Mon,Tue,Wed
11:41	14:44	15:44	19:57	07:16	Mon,Tue,Wed
12:30	15:18	16:05	20:21	07:04	Mon,Tue,Wed
12:44	15:37	16:19	20:37	07:11	Mon,Tue,Wed
13:19	16:16	17:15	21:21	07:03	Mon,Tue,Wed
13:54	16:50	17:36	21:51	07:11	Mon,Tue,Wed
14:15	18:35	19:17	22:11	07:14	Mon,Tue,Wed
15:04	19:23	20:23	24:21	08:17	Mon,Tue,Wed
15:53	20:03	20:53	24:51	08:08	Mon,Tue,Wed
16:05	20:23	21:23	25:21	08:16	Mon,Tue,Wed
16:20	20:43	21:43	25:45	08:25	Mon,Tue,Wed
16:21	20:53	21:53	25:52	08:31	Mon,Tue,Wed
16:35	21:13	22:13	24:56	07:21	Mon,Tue,Wed
19:28	22:33	23:33	28:00	07:32	Mon,Tue,Wed
19:48	22:55	23:55	28:30	07:42	Mon,Tue,Wed
19:58	23:46	24:31	29:05	08:22	Mon,Tue,Wed
03:33	07:38	08:25	11:25	07:05	Thu
03:45	07:31	08:31	12:49	08:04	Thu
03:48	07:52	08:37	12:40	08:07	Thu
04:03	08:13	09:13	13:25	08:22	Thu
04:18	07:03	07:43	11:55	06:57	Thu
04:33	07:24	08:07	12:30	07:14	Thu
05:19	09:34	10:25	14:43	08:33	Thu
05:34	10:07	11:07	15:21	08:47	Thu
05:41	08:37	09:25	13:42	07:13	Thu
05:55	10:25	11:25	14:24	07:29	Thu
06:09	10:37	11:37	16:02	08:53	Thu
06:23	10:55	11:55	16:20	08:57	Thu
06:44	11:31	12:31	16:56	09:12	Thu
07:05	10:10	10:55	13:49	05:59	Thu
07:19	12:01	13:01	17:32	09:13	Thu
07:45	12:31	13:31	17:55	09:10	Thu
08:50	13:25	14:25	18:59	09:09	Thu
09:38	13:45	14:43	19:08	08:32	Thu
09:56	14:03	15:01	19:35	08:41	Thu
10:08	14:31	15:31	19:50	08:42	Thu
12:02	14:53	15:53	20:25	07:23	Thu
13:14	16:11	17:07	21:21	07:11	Thu
13:32	17:52	18:46	24:01	09:35	Thu
13:50	16:47	17:35	21:51	07:13	Thu
13:56	16:53	17:42	20:43	05:58	Thu
14:02	18:20	19:10	24:21	09:29	Thu
15:32	19:48	20:33	25:45	09:28	Thu
15:52			20:19	04:27	Thu
16:20	20:30	21:23	25:21	08:08	Thu
16:27	20:53	21:53	25:52	08:25	Thu
16:34	21:13	22:13	26:05	08:31	Thu
19:28	22:33	23:33	28:00	07:32	Thu
19:48	22:55	23:55	28:30	07:42	Thu
20:48	24:43	25:43	29:00	07:12	Thu

<colgroup><col span="5"><col></colgroup><tbody>
</tbody>

Thanks and Regards
Asad

 

[asad]

No need to worry about meal breaks as the cars are still in the car park. This whole excercise is just to determine the number of car spaces we need.
I have already worked out the answer but would like to know a better approach for easy calculation next week.
We have constant increase and decrease of employees ?.

 

[DanteAmor]

Maybe you need this


<b></b><br /><br /><table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:71.29px;" /><col style="width:53.23px;" /><col style="width:80.79px;" /><col style="width:78.89px;" /><col style="width:78.89px;" /><col style="width:53.23px;" /><col style="width:105.5px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Employee</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Start</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Meal Start</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Meal End</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Finish</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Total</td><td style="background-color:#92d050; font-weight:bold; font-family:Verdana; text-align:center; ">Day</td><td style="background-color:#92d050; font-weight:bold; text-align:center; ">Formula</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td style="font-family:Verdana; text-align:right; ">03:33</td><td style="font-family:Verdana; text-align:right; ">06:27</td><td style="font-family:Verdana; text-align:right; ">07:27</td><td style="font-family:Verdana; text-align:right; ">11:44</td><td style="font-family:Verdana; text-align:right; ">07:11</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td style="font-family:Verdana; text-align:right; ">03:45</td><td style="font-family:Verdana; text-align:right; ">07:30</td><td style="font-family:Verdana; text-align:right; ">08:16</td><td style="font-family:Verdana; text-align:right; ">12:33</td><td style="font-family:Verdana; text-align:right; ">08:02</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td style="font-family:Verdana; text-align:right; ">03:48</td><td style="font-family:Verdana; text-align:right; ">07:48</td><td style="font-family:Verdana; text-align:right; ">08:37</td><td style="font-family:Verdana; text-align:right; ">12:47</td><td style="font-family:Verdana; text-align:right; ">08:10</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td style="font-family:Verdana; text-align:right; ">04:03</td><td style="font-family:Verdana; text-align:right; ">06:56</td><td style="font-family:Verdana; text-align:right; ">07:41</td><td style="font-family:Verdana; text-align:right; ">11:58</td><td style="font-family:Verdana; text-align:right; ">07:10</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td style="font-family:Verdana; text-align:right; ">04:18</td><td style="font-family:Verdana; text-align:right; ">08:30</td><td style="font-family:Verdana; text-align:right; ">09:19</td><td style="font-family:Verdana; text-align:right; ">12:12</td><td style="font-family:Verdana; text-align:right; ">07:05</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td style="font-family:Verdana; text-align:right; ">04:33</td><td style="font-family:Verdana; text-align:right; ">08:43</td><td style="font-family:Verdana; text-align:right; ">09:33</td><td style="font-family:Verdana; text-align:right; ">13:43</td><td style="font-family:Verdana; text-align:right; ">08:20</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">6</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td > </td><td style="font-family:Verdana; text-align:right; ">05:03</td><td style="font-family:Verdana; text-align:right; ">09:21</td><td style="font-family:Verdana; text-align:right; ">10:01</td><td style="font-family:Verdana; text-align:right; ">12:59</td><td style="font-family:Verdana; text-align:right; ">07:16</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">7</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td style="font-family:Verdana; text-align:right; ">05:10</td><td style="font-family:Verdana; text-align:right; ">09:28</td><td style="font-family:Verdana; text-align:right; ">10:15</td><td style="font-family:Verdana; text-align:right; ">13:08</td><td style="font-family:Verdana; text-align:right; ">07:11</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">8</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td style="font-family:Verdana; text-align:right; ">05:25</td><td style="font-family:Verdana; text-align:right; ">09:47</td><td style="font-family:Verdana; text-align:right; ">10:43</td><td style="font-family:Verdana; text-align:right; ">13:36</td><td style="font-family:Verdana; text-align:right; ">07:15</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">9</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td style="font-family:Verdana; text-align:right; ">05:40</td><td style="font-family:Verdana; text-align:right; ">10:25</td><td style="font-family:Verdana; text-align:right; ">11:25</td><td style="font-family:Verdana; text-align:right; ">14:18</td><td style="font-family:Verdana; text-align:right; ">07:38</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">10</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td > </td><td style="font-family:Verdana; text-align:right; ">05:55</td><td style="font-family:Verdana; text-align:right; ">10:10</td><td style="font-family:Verdana; text-align:right; ">11:04</td><td style="font-family:Verdana; text-align:right; ">14:02</td><td style="font-family:Verdana; text-align:right; ">07:13</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">11</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td > </td><td style="font-family:Verdana; text-align:right; ">06:03</td><td style="font-family:Verdana; text-align:right; ">10:53</td><td style="font-family:Verdana; text-align:right; ">11:53</td><td style="font-family:Verdana; text-align:right; ">16:07</td><td style="font-family:Verdana; text-align:right; ">09:04</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">12</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td > </td><td style="font-family:Verdana; text-align:right; ">06:33</td><td style="font-family:Verdana; text-align:right; ">11:14</td><td style="font-family:Verdana; text-align:right; ">12:14</td><td style="font-family:Verdana; text-align:right; ">16:33</td><td style="font-family:Verdana; text-align:right; ">09:00</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">13</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td > </td><td style="font-family:Verdana; text-align:right; ">08:18</td><td style="font-family:Verdana; text-align:right; ">11:28</td><td style="font-family:Verdana; text-align:right; ">12:28</td><td style="font-family:Verdana; text-align:right; ">16:42</td><td style="font-family:Verdana; text-align:right; ">07:24</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td > </td><td style="font-family:Verdana; text-align:right; ">08:20</td><td style="font-family:Verdana; text-align:right; ">12:38</td><td style="font-family:Verdana; text-align:right; ">13:38</td><td style="font-family:Verdana; text-align:right; ">18:01</td><td style="font-family:Verdana; text-align:right; ">08:41</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">15</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td > </td><td style="font-family:Verdana; text-align:right; ">08:50</td><td style="font-family:Verdana; text-align:right; ">13:13</td><td style="font-family:Verdana; text-align:right; ">14:13</td><td style="font-family:Verdana; text-align:right; ">18:43</td><td style="font-family:Verdana; text-align:right; ">08:53</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">16</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td > </td><td style="font-family:Verdana; text-align:right; ">09:07</td><td style="font-family:Verdana; text-align:right; ">12:17</td><td style="font-family:Verdana; text-align:right; ">13:17</td><td style="font-family:Verdana; text-align:right; ">17:40</td><td style="font-family:Verdana; text-align:right; ">07:33</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">17</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td > </td><td style="font-family:Verdana; text-align:right; ">11:34</td><td style="font-family:Verdana; text-align:right; ">14:27</td><td style="font-family:Verdana; text-align:right; ">15:23</td><td style="font-family:Verdana; text-align:right; ">19:49</td><td style="font-family:Verdana; text-align:right; ">07:19</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">18</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td > </td><td style="font-family:Verdana; text-align:right; ">11:41</td><td style="font-family:Verdana; text-align:right; ">14:44</td><td style="font-family:Verdana; text-align:right; ">15:44</td><td style="font-family:Verdana; text-align:right; ">19:57</td><td style="font-family:Verdana; text-align:right; ">07:16</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="background-color:#ffff00; text-align:right; ">19</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td > </td><td style="font-family:Verdana; text-align:right; ">12:30</td><td style="font-family:Verdana; text-align:right; ">15:18</td><td style="font-family:Verdana; text-align:right; ">16:05</td><td style="font-family:Verdana; text-align:right; ">20:21</td><td style="font-family:Verdana; text-align:right; ">07:04</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">17</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td > </td><td style="font-family:Verdana; text-align:right; ">12:44</td><td style="font-family:Verdana; text-align:right; ">15:37</td><td style="font-family:Verdana; text-align:right; ">16:19</td><td style="font-family:Verdana; text-align:right; ">20:37</td><td style="font-family:Verdana; text-align:right; ">07:11</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">17</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td > </td><td style="font-family:Verdana; text-align:right; ">13:19</td><td style="font-family:Verdana; text-align:right; ">16:16</td><td style="font-family:Verdana; text-align:right; ">17:15</td><td style="font-family:Verdana; text-align:right; ">21:21</td><td style="font-family:Verdana; text-align:right; ">07:03</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">15</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td > </td><td style="font-family:Verdana; text-align:right; ">13:54</td><td style="font-family:Verdana; text-align:right; ">16:50</td><td style="font-family:Verdana; text-align:right; ">17:36</td><td style="font-family:Verdana; text-align:right; ">21:51</td><td style="font-family:Verdana; text-align:right; ">07:11</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td > </td><td style="font-family:Verdana; text-align:right; ">14:15</td><td style="font-family:Verdana; text-align:right; ">18:35</td><td style="font-family:Verdana; text-align:right; ">19:17</td><td style="font-family:Verdana; text-align:right; ">22:11</td><td style="font-family:Verdana; text-align:right; ">07:14</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >27</td><td > </td><td style="font-family:Verdana; text-align:right; ">15:04</td><td style="font-family:Verdana; text-align:right; ">19:23</td><td style="font-family:Verdana; text-align:right; ">20:23</td><td style="font-family:Verdana; text-align:right; ">24:21:00</td><td style="font-family:Verdana; text-align:right; ">08:17</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >28</td><td > </td><td style="font-family:Verdana; text-align:right; ">15:53</td><td style="font-family:Verdana; text-align:right; ">20:03</td><td style="font-family:Verdana; text-align:right; ">20:53</td><td style="font-family:Verdana; text-align:right; ">24:51:00</td><td style="font-family:Verdana; text-align:right; ">08:08</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">15</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >29</td><td > </td><td style="font-family:Verdana; text-align:right; ">16:05</td><td style="font-family:Verdana; text-align:right; ">20:23</td><td style="font-family:Verdana; text-align:right; ">21:23</td><td style="font-family:Verdana; text-align:right; ">25:21:00</td><td style="font-family:Verdana; text-align:right; ">08:16</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">16</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >30</td><td > </td><td style="font-family:Verdana; text-align:right; ">16:20</td><td style="font-family:Verdana; text-align:right; ">20:43</td><td style="font-family:Verdana; text-align:right; ">21:43</td><td style="font-family:Verdana; text-align:right; ">25:45:00</td><td style="font-family:Verdana; text-align:right; ">08:25</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">16</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >31</td><td > </td><td style="font-family:Verdana; text-align:right; ">16:21</td><td style="font-family:Verdana; text-align:right; ">20:53</td><td style="font-family:Verdana; text-align:right; ">21:53</td><td style="font-family:Verdana; text-align:right; ">25:52:00</td><td style="font-family:Verdana; text-align:right; ">08:31</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">17</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >32</td><td > </td><td style="font-family:Verdana; text-align:right; ">16:35</td><td style="font-family:Verdana; text-align:right; ">21:13</td><td style="font-family:Verdana; text-align:right; ">22:13</td><td style="font-family:Verdana; text-align:right; ">24:56:00</td><td style="font-family:Verdana; text-align:right; ">07:21</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">17</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >33</td><td > </td><td style="font-family:Verdana; text-align:right; ">19:28</td><td style="font-family:Verdana; text-align:right; ">22:33</td><td style="font-family:Verdana; text-align:right; ">23:33</td><td style="font-family:Verdana; text-align:right; ">28:00:00</td><td style="font-family:Verdana; text-align:right; ">07:32</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >34</td><td > </td><td style="font-family:Verdana; text-align:right; ">19:48</td><td style="font-family:Verdana; text-align:right; ">22:55</td><td style="font-family:Verdana; text-align:right; ">23:55</td><td style="font-family:Verdana; text-align:right; ">28:30:00</td><td style="font-family:Verdana; text-align:right; ">07:42</td><td style="font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">15</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >35</td><td > </td><td style="background-color:#b3c6e7; font-family:Verdana; text-align:right; ">19:58</td><td style="background-color:#b3c6e7; font-family:Verdana; text-align:right; ">23:46</td><td style="background-color:#b3c6e7; font-family:Verdana; text-align:right; ">24:31:00</td><td style="background-color:#b3c6e7; font-family:Verdana; text-align:right; ">29:05:00</td><td style="background-color:#b3c6e7; font-family:Verdana; text-align:right; ">08:22</td><td style="background-color:#b3c6e7; font-family:Verdana; ">Mon,Tue,Wed</td><td style="text-align:right; ">14</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >H3</td><td >=COUNTIFS($B$3:$B$35,"<="&B3,$E$3:$E$35,">="&B3)</td></tr></table></td></tr></table> <br /><br />

 

[asad]

Perfect. Thanks a lot DanteAmor.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.