Rajesh,

Here's one formula;a for between 7 & 8 for Exec A

=SUMPRODUCT(($A$1:$A$20=TIME(7,0,0))*($A$1:$A$20< TIME(8,0,0))*($B$1:$B$20="
A"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rajesh Sharma" wrote in message
...
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!