Comparing dates/times 'within' set dates/times

in the second sheet what is the need for both beginning time and end time. these are not the end time of the call. for example take your first case. when did the call start. If it started at 09 hours then it ended at 09:00:18(that is 9 hours and 18 secnds). the end time is not necessary , duration would be enought.

in my regional case if the date is 1st april 2010 this is entered as 4/1/10.

why not incorporate both date and time in one cell instead of having a separate cell for dates.
for e.g enter 4/1/0 09:00:00

Originally Posted by foxguy

Your problem doesn't sound hard, but it would be a big help if you posted a workbook with sample data.
In your message Click "Edit" then "Go Advance", then click the Paper Clip at the top or scroll down and click "Manage Attachments", then click "Browse" to find your file on your computer, then click "Upload", then"Close Window" & "Save Changes"

Foxguy

Ive attached a sample covering 1st and 2nd March
The first sheet has call details (number of calls, time to answer, lost calls etc) the second has the team leader shift patterns with a note of which team leader was working.

So I guess what Im looking to do is to take the call data for the timeslots that exist within the team leader shifts and provide a summary by team leader.

eg TL A shift 1st March 00:00 to 07:59 and the team took 56 calls, average time to answer 10 seconds etc etc etc

Many thanks in advance

Originally Posted by foxguy

JimFiggs;

Here's a file Attachment 74118.
I couldn't figure out how you calculated "% in Tgt" & "% Out Tgt", so I left them for you to calculate. Hopefully the formulas I've done will help you figure them out.

One Note: You have 3/1/10 Finish of "00:00". I had to change that to 3/2/10 "00:00" in sheets("Call Info by Hour").Column "O" to make the formulas work because 3/1/10 00:00 should be 3/1/10 24:00, but times stop at 23:59:59.

Foxguy

Many thanks for the prompt action, apologies for my delayed reply, Its been a while since Ive logged on.

What you've done looks good at an initial glance, much appreciated.

I'll take a closer look now and 'may' get back to you

Regards