Hi,

We have a xls sheet that records when phone calls have been made. We have a column that works out the day from the date inputed (TEXT(WEEKDAY)function) and the time of the actual call. We need to calculate the number of phone calls on a specified day AND between a particular time (eg.No. of calls on Saturday between 09:00 - 13:00). We would like numerous ranges E.g. Saturday 09:00-12:59, Saturday 13:00-16:59, Sunday 08:00-11:59, Monday ..etc.).

Our workbook looks similar to this:


Date Day of Week Time of Call

01/07/06 Saturday 12:07

and so on

So far we have been through all the functions and formula we can think of, but have hit a brick wall!

Can someone please help us? Would be very much appreciated!