Countif within time range

Newbie987654321

New Member
Joined
Mar 13, 2018
Messages
9
Hi Guys,

I need your help. I need to know how many artists in total are in within a time range.
I need a formula to put into table 2 to get the number of artists. I just did this manually. LOL
I tried SUMPRODUCT but it will only give me the number on artists on based on their Time In, but I actually need the total number of artist until their Time Out.

I tried this but it was no good.
=SUMPRODUCT(--(HOUR($E$3:$E$18)>=H3),--(HOUR($E$3:$E$18)<i3))


Here's the table.

[TABLE="width: 476"]
<tbody>[TR]
[TD]TABLE 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]TABLE 2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Artist
[/TD]
[TD]Time in
[/TD]
[TD]Time Out
[/TD]
[TD][/TD]
[TD="colspan: 2"]Time in Duration
[/TD]
[TD]Artists
[/TD]
[/TR]
[TR]
[TD]Sam Smith
[/TD]
[TD]9:00 PM
[/TD]
[TD]6:00 AM
[/TD]
[TD][/TD]
[TD]9:00 PM
[/TD]
[TD]9:30 PM
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Justin Bieber
[/TD]
[TD]9:00 PM
[/TD]
[TD]6:00 AM
[/TD]
[TD][/TD]
[TD]9:30 PM
[/TD]
[TD]10:00 PM
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]Selena Gomez
[/TD]
[TD]9:30 PM
[/TD]
[TD]6:30 AM
[/TD]
[TD][/TD]
[TD]10:00 PM
[/TD]
[TD]10:30 PM
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD]Britney Spears
[/TD]
[TD]10:00 PM
[/TD]
[TD]7:00 AM
[/TD]
[TD][/TD]
[TD]10:30 PM
[/TD]
[TD]11:00 PM
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Christina Aguilera
[/TD]
[TD]10:45 PM
[/TD]
[TD]7:45 AM
[/TD]
[TD][/TD]
[TD]11:00 PM
[/TD]
[TD]11:30 PM
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Elle King
[/TD]
[TD]11:45 PM
[/TD]
[TD]8:45 AM
[/TD]
[TD][/TD]
[TD]11:30 PM
[/TD]
[TD]12:00 AM
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]Miley Cyrus
[/TD]
[TD]11:45 PM
[/TD]
[TD]8:45 AM
[/TD]
[TD][/TD]
[TD]12:00 AM
[/TD]
[TD]12:30 AM
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]Angelina Jolie
[/TD]
[TD]12:00 AM
[/TD]
[TD]9:00 AM
[/TD]
[TD][/TD]
[TD]12:30 AM
[/TD]
[TD]1:00 AM
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD]Brad Pitt
[/TD]
[TD]1:00 AM
[/TD]
[TD]10:00 AM
[/TD]
[TD][/TD]
[TD]1:00 AM
[/TD]
[TD]1:30 AM
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]Justin Timberlake
[/TD]
[TD]2:00 AM
[/TD]
[TD]11:00 AM
[/TD]
[TD][/TD]
[TD]1:30 AM
[/TD]
[TD]2:00 AM
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]Pink
[/TD]
[TD]3:00 AM
[/TD]
[TD]12:00 PM
[/TD]
[TD][/TD]
[TD]2:00 AM
[/TD]
[TD]2:30 AM
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]Amy Lee
[/TD]
[TD]3:00 AM
[/TD]
[TD]12:00 PM
[/TD]
[TD][/TD]
[TD]2:30 AM
[/TD]
[TD]3:00 AM
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3:00 AM
[/TD]
[TD]3:30 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3:30 AM
[/TD]
[TD]4:00 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4:00 AM
[/TD]
[TD]4:30 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4:30 AM
[/TD]
[TD]5:00 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5:00 AM
[/TD]
[TD]5:30 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5:30 AM
[/TD]
[TD]6:00 AM
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6:00 AM
[/TD]
[TD]6:30 AM
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6:30 AM
[/TD]
[TD]7:00 AM
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7:00 AM
[/TD]
[TD]7:30 AM
[/TD]
[TD]8
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7:30 AM
[/TD]
[TD]8:00 AM
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8:00 AM
[/TD]
[TD]8:30 AM
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8:30 AM
[/TD]
[TD]9:00 AM
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9:00 AM
[/TD]
[TD]9:30 AM
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9:30 AM
[/TD]
[TD]10:00 AM
[/TD]
[TD]4
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10:00 AM
[/TD]
[TD]10:30 AM
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]10:30 AM
[/TD]
[TD]11:00 AM
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11:00 AM
[/TD]
[TD]11:30 AM
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11:30 AM
[/TD]
[TD]12:00 PM
[/TD]
[TD]2
[/TD]
[/TR]
</tbody>[/TABLE]
</i3))
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
The reason that SUMPRODUCT would not work as is in this instance is that excel does not realize that the morning hours, should still fall within the appropriate range (i.e. Hour(9PM) = 21, Hour(1AM) = 1). You can try to incorporate a date in with the time that way the values are going in a continuous order or have some hidden rows to do such a calculation.
 
Upvote 0
Hi!

Maybe the formula below can helps:

In G4 and copy down

=SUMPRODUCT(--(B$4:B$15<=E4),--(F4<=B$4:B$15+MOD(C$4:C$15-B$4:B$15,1)))


[TABLE="class: grid, width: 550"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Artist[/TD]
[TD="align: center"]Time in[/TD]
[TD="align: center"]Time Out[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Time in Duration[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Artists[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Sam Smith[/TD]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21:00[/TD]
[TD="align: center"]21:30[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Justin Bieber[/TD]
[TD="align: center"]21:00[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21:30[/TD]
[TD="align: center"]22:00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Selena Gomez[/TD]
[TD="align: center"]21:30[/TD]
[TD="align: center"]06:30[/TD]
[TD="align: center"][/TD]
[TD="align: center"]22:00[/TD]
[TD="align: center"]22:30[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]Britney Spears[/TD]
[TD="align: center"]22:00[/TD]
[TD="align: center"]07:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]22:30[/TD]
[TD="align: center"]23:00[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]Christina Aguilera[/TD]
[TD="align: center"]22:45[/TD]
[TD="align: center"]07:45[/TD]
[TD="align: center"][/TD]
[TD="align: center"]23:00[/TD]
[TD="align: center"]23:30[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]Elle King[/TD]
[TD="align: center"]23:45[/TD]
[TD="align: center"]08:45[/TD]
[TD="align: center"][/TD]
[TD="align: center"]23:30[/TD]
[TD="align: center"]24:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]Miley Cyrus[/TD]
[TD="align: center"]23:45[/TD]
[TD="align: center"]08:45[/TD]
[TD="align: center"][/TD]
[TD="align: center"]00:00[/TD]
[TD="align: center"]00:30[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]Angelina Jolie[/TD]
[TD="align: center"]00:00[/TD]
[TD="align: center"]09:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]00:30[/TD]
[TD="align: center"]01:00[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]Brad Pitt[/TD]
[TD="align: center"]01:00[/TD]
[TD="align: center"]10:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]01:00[/TD]
[TD="align: center"]01:30[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]Justin Timberlake[/TD]
[TD="align: center"]02:00[/TD]
[TD="align: center"]11:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]01:30[/TD]
[TD="align: center"]02:00[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]Pink[/TD]
[TD="align: center"]03:00[/TD]
[TD="align: center"]12:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]02:00[/TD]
[TD="align: center"]02:30[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]Amy Lee[/TD]
[TD="align: center"]03:00[/TD]
[TD="align: center"]12:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]02:30[/TD]
[TD="align: center"]03:00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03:00[/TD]
[TD="align: center"]03:30[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03:30[/TD]
[TD="align: center"]04:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]04:00[/TD]
[TD="align: center"]04:30[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]04:30[/TD]
[TD="align: center"]05:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]05:00[/TD]
[TD="align: center"]05:30[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]05:30[/TD]
[TD="align: center"]06:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]***[/TD]
[TD="align: center"]****************[/TD]
[TD="align: center"]********[/TD]
[TD="align: center"]*********[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]****************[/TD]
[TD="align: center"]******[/TD]
[TD="align: center"]*******[/TD]
[TD="align: center"]**[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
 
Upvote 0
Hi Mark, I appreciate your help on this. It's almost there however the 23:45 should be counted within the 22:30-23:00 time range. And so far, the numbers are different from the table 2 results I was looking for. By the way, the columns E and F is the range for Time In.
So basically, from 9PM to 3AM, the number of artists should gradually increase, then by 6AM onwards it goes down as some of them times out.
 
Upvote 0
Hi Mark, I appreciate your help on this. It's almost there however the 23:45 should be counted within the 22:30-23:00 time range. And so far, the numbers are different from the table 2 results I was looking for. By the way, the columns E and F is the range for Time In.
So basically, from 9PM to 3AM, the number of artists should gradually increase, then by 6AM onwards it goes down as some of them times out.

Hi!

I'm sorry but I didn't understand what you want.

Could you explain better? With more examples.

Why 23:45 shoud be counted for the range 22:30 to 23:00?

Markmzz
 
Upvote 0
Hi!

I'm sorry but I didn't understand what you want.

Could you explain better? With more examples.

Why 23:45 shoud be counted for the range 22:30 to 23:00?

Markmzz


Hi. Sorry for thr confusion, i meant 22:45 should be counted on a 2230-2300 time in range. With that, I mean Time In Duration 2230-2300 should be 5.
Then by 3am all artists should be there since the last artist comes in at 3am. So 0300-330 should be 12 until 6am.
The around 0600-0630, since 2 artists times out it should then decrease to 10. and so forth.
 
Upvote 0
Hi. Sorry for thr confusion, i meant 22:45 should be counted on a 2230-2300 time in range. With that, I mean Time In Duration 2230-2300 should be 5.
Then by 3am all artists should be there since the last artist comes in at 3am. So 0300-330 should be 12 until 6am.
The around 0600-0630, since 2 artists times out it should then decrease to 10. and so forth.

Hi!

I'm sorry, but I don't know how do that until now.

I think that Iggy_ (post #2) is right. We need to incorporate a date.

Anyway, lets wait for another user.

Ps: If I have another suggestion, I'll post here again.

Markmzz
 
Upvote 0
Hi!

Anyway, here is my formula with Iggy_ (post #2) sugestion:


[TABLE="class: grid, width: 592"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Artist[/TD]
[TD="align: center"]Time in[/TD]
[TD="align: center"]Time Out[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Time in Duration[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Artists[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Sam Smith[/TD]
[TD="align: center"]21:00:00[/TD]
[TD="align: center"]06:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21:00:00[/TD]
[TD="align: center"]21:30:00[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Justin Bieber[/TD]
[TD="align: center"]21:00:00[/TD]
[TD="align: center"]06:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]21:30:00[/TD]
[TD="align: center"]22:00:00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Selena Gomez[/TD]
[TD="align: center"]21:30:00[/TD]
[TD="align: center"]06:30:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]22:00:00[/TD]
[TD="align: center"]22:30:00[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]Britney Spears[/TD]
[TD="align: center"]22:00:00[/TD]
[TD="align: center"]07:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]22:30:00[/TD]
[TD="align: center"]23:00:00[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]Christina Aguilera[/TD]
[TD="align: center"]22:45:00[/TD]
[TD="align: center"]07:45:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]23:00:00[/TD]
[TD="align: center"]23:30:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]Elle King[/TD]
[TD="align: center"]23:45:00[/TD]
[TD="align: center"]08:45:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]23:30:00[/TD]
[TD="align: center"]00:00:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]Miley Cyrus[/TD]
[TD="align: center"]23:45:00[/TD]
[TD="align: center"]08:45:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]00:00:00[/TD]
[TD="align: center"]00:30:00[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]Angelina Jolie[/TD]
[TD="align: center"]00:00:00[/TD]
[TD="align: center"]09:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]00:30:00[/TD]
[TD="align: center"]01:00:00[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]Brad Pitt[/TD]
[TD="align: center"]01:00:00[/TD]
[TD="align: center"]10:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]01:00:00[/TD]
[TD="align: center"]01:30:00[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]Justin Timberlake[/TD]
[TD="align: center"]02:00:00[/TD]
[TD="align: center"]11:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]01:30:00[/TD]
[TD="align: center"]02:00:00[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]Pink[/TD]
[TD="align: center"]03:00:00[/TD]
[TD="align: center"]12:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]02:00:00[/TD]
[TD="align: center"]02:30:00[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]Amy Lee[/TD]
[TD="align: center"]03:00:00[/TD]
[TD="align: center"]12:00:00[/TD]
[TD="align: center"][/TD]
[TD="align: center"]02:30:00[/TD]
[TD="align: center"]03:00:00[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03:00:00[/TD]
[TD="align: center"]03:30:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]03:30:00[/TD]
[TD="align: center"]04:00:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]04:00:00[/TD]
[TD="align: center"]04:30:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]04:30:00[/TD]
[TD="align: center"]05:00:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]05:00:00[/TD]
[TD="align: center"]05:30:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]05:30:00[/TD]
[TD="align: center"]06:00:00[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]06:00:00[/TD]
[TD="align: center"]06:30:00[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]06:30:00[/TD]
[TD="align: center"]07:00:00[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]07:00:00[/TD]
[TD="align: center"]07:30:00[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]07:30:00[/TD]
[TD="align: center"]08:00:00[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]08:00:00[/TD]
[TD="align: center"]08:30:00[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]08:30:00[/TD]
[TD="align: center"]09:00:00[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]09:00:00[/TD]
[TD="align: center"]09:30:00[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]09:30:00[/TD]
[TD="align: center"]10:00:00[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10:00:00[/TD]
[TD="align: center"]10:30:00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]10:30:00[/TD]
[TD="align: center"]11:00:00[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11:00:00[/TD]
[TD="align: center"]11:30:00[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]11:30:00[/TD]
[TD="align: center"]12:00:00[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]***[/TD]
[TD="align: center"]****************[/TD]
[TD="align: center"]********[/TD]
[TD="align: center"]*********[/TD]
[TD="align: center"]**[/TD]
[TD="align: center"]****************[/TD]
[TD="align: center"]******[/TD]
[TD="align: center"]*******[/TD]
[TD="align: center"]**[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
 
Upvote 0

Forum statistics

Threads
1,223,905
Messages
6,175,297
Members
452,633
Latest member
DougMo

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