Hi all,
I have a database which gives me the total calls taken by different
executives in a day and also the time at which each particular call was
recorded eg. 7:53:35 PM
i need to find a count of the calls taken by each in every hour . ie
hourly call breakup .. eg.

Time Slab Exec A Exec B Exec C
----------------------------------------------------------
Between 8 to 9 AM 10 8 5
Between 9 to 10 AM 8 11 12

i want to do this in Excel 97'. How can I get this using the countif
function
Please revert asap

Warm regards,
Rajesh

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!