Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ian Jones
 
Posts: n/a
Default Countif("between start/end times)



Sheet 1, Row 1, Column 2 - opening hours divide into 15min segments. B1 -
08:00, C2 - 08:15, D2 - 08:30, and so on.

Sheet 2 , Columns 1 and 2 - a list of each agents break times. Column A -
Start time (eg 10:00) and Column B - End time (eg 10:30).

Sheet 1, Row 2, Column 1 - summary titles. (eg Cell A2 - "Morning Break").

Problem: I need to summarise the number of agents away on, say, "Morning
Break" per 15 min segment.
So, B2 must count the number of people on "Morning Break" at 08:00, B3..the
number of people of people on morning break at 08:15, and so on, based on the
list of start/end times found on Sheet 2.

=Countif(Sheet2!A:A, Sheet1!B1) inserted into Sheet 1 cell B2 is not
sufficient as it counts the number of people whose breaks begin at 08:00 only.

Thanks in advance.

Ian
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need a template for weekly scheduling of golf tee times crazforgolf Charts and Charting in Excel 0 January 8th 05 05:21 AM
Adding/Averaging Times in Excel JD Excel Discussion (Misc queries) 2 January 5th 05 06:07 PM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 11:39 PM
Need help with conditional rates and roster times for payroll Ricky Excel Discussion (Misc queries) 1 December 9th 04 05:23 PM
Times and Frequency? Jim Excel Discussion (Misc queries) 3 December 2nd 04 07:36 PM


All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"