Sorry, the first part of the formula should be "=" rather than just
"".

Pete

On Nov 22, 11:57 am, Pete_UK wrote:
Call data usually covers the calls you make, rather than calls
received.

It would be better to draw up a list of 15minute intervals on a
separate sheet - perhaps starting in A1. You can do this by entering
00:00:00 in A1, then in A2 entering this formula:

=A1+TIME(0,15,0)

and copying this down the column to cover a full day. Format the cells
as [h]:mm:ss

Then in B2 you can enter the formula:

=COUNTIF(time_range,""&A1)-COUNTIF(time_range,"="&A2)

where time_range is your range on the other sheet, eg Sheet1!E$2:E
$1000

Then copy this formula down.

Hope this helps.

Pete

On Nov 22, 11:10 am, Andrew@rushington



wrote:
i have a list of telephone calls recieved with the time of the call over a 1
day (8hour) period. i need to report how many calls recieved in 15 min
intervals. useing excel 2003- Hide quoted text -

- Show quoted text -