We are a call center. open from 8a-9PM 7 days a week.
However, our local stores are open only from 8:30 AM - 5:30 PM.
In the excel spreadsheet we log the following
A-Facility Code & Street Name
B-Date
C-Time
D-Name
E-Type Call Code Notations
the letters of course represent which column each piece of information is placed in.
On average we take about 200 calls for this specific location I am attempting to calculate. Now here is the dilema. They are thinking of adding more staff but need to know how many calls we take before/after the stores normal operating hours. So I need a formula that tells me how many calls came in from 17:30 - 08:30 each day of the week. The dates are in the format 05/02/02 and times are all in militay time. To be honest. I am totalllllly clueless where even to begin on a formula that could do this. ANY ideas or formulas would be thouroughly appreciated.
Snedman
However, our local stores are open only from 8:30 AM - 5:30 PM.
In the excel spreadsheet we log the following
A-Facility Code & Street Name
B-Date
C-Time
D-Name
E-Type Call Code Notations
the letters of course represent which column each piece of information is placed in.
On average we take about 200 calls for this specific location I am attempting to calculate. Now here is the dilema. They are thinking of adding more staff but need to know how many calls we take before/after the stores normal operating hours. So I need a formula that tells me how many calls came in from 17:30 - 08:30 each day of the week. The dates are in the format 05/02/02 and times are all in militay time. To be honest. I am totalllllly clueless where even to begin on a formula that could do this. ANY ideas or formulas would be thouroughly appreciated.
Snedman