Formula to count max employees at any time

asad

Well-known Member
Joined
Sep 9, 2008
Messages
1,434
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.

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

[/TD]
[/TR]
</tbody>[/TABLE]


Thanks and Regards
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 ?.
 
Upvote 0

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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 />
 
Upvote 0

Forum statistics

Threads
1,223,967
Messages
6,175,672
Members
452,666
Latest member
AllexDee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top