Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a template for weekly scheduling of golf tee times | Charts and Charting in Excel | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
Times and Frequency? | Excel Discussion (Misc queries) |