# Look up a specific Name & Count Times Between 2 Specified Times (15 min intervals)

1. ## Look up a specific Name & Count Times Between 2 Specified Times (15 min intervals)

Hi All,

This is a tricky one but just need some help with a formula, to look up a Name from the Output tab A column and count the times between 2 specified Times (15 min intervals) which is in rows 1 and 2 and match the data from the input tab to return the data in Output B3 cell.

I have an example sheet attached.
exampleworkflow.xlsx

2. ## Re: Look up a specific Name & Count Times Between 2 Specified Times (15 min intervals)

Hi,

In cell B3 and copy across and down as required:

=SUMPRODUCT((Input!\$A\$2:\$A\$389=Output!\$A3)*(MOD(Input!\$B\$2:\$B\$389,1)>=Output!B\$1)*(MOD(Input!\$B\$2:\$B\$389,1)<=Output!B\$2))

Regards

3. ## Re: Look up a specific Name & Count Times Between 2 Specified Times (15 min intervals)

hi arrekkusu03, another alternative:
=SUMPRODUCT(--(Input!\$A\$2:\$A\$389=\$A3),--(MOD(Input!\$B\$2:\$B\$389,1)>=B\$1),--(MOD(Input!\$B\$2:\$B\$389,1)<=B\$2))

4. ## Re: Look up a specific Name & Count Times Between 2 Specified Times (15 min intervals)

What is the expected output of B3 cell?

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1