Counting the total time...

**kishoremcp** · 01-26-2012, 06:09 PM

I am able to calculate the total number of Chats Served (Column K13) but not getting the AHT Handeled (AS13) using the same formula.
Please help me.
Attaching the data for testing.

=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!K1:K53)

I am using the below formula to get the handeled AHT i am not getting it...

=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!AS1:AS53)

I am sorry to change the sheet1 name to "Page 1". Please change it and help me. Even after changing the sheet name it is not working.

Please help.

**vlady** · 01-26-2012, 06:23 PM

Try to "unmerge" the cells being computed.

**kishoremcp** · 01-26-2012, 06:26 PM

I cannot unmerge the cells because it is very hard to do if for 200 sheets daily for every 30 minutes. Because I have to do it for every 30min.
But the first formula for counting the total number of chats handeded is getting the correct output. Just not getting the total handeled time even through they are merged. I hope u understand my problem and help me in fixing the problem.

**vlady** · 01-26-2012, 09:23 PM

I think the problem is in the time format of AS1:AS53 ( it is in general )

If you can change the format to h:mm:ss BEFORE entering the numbers e.g. 00:51:16
then format the cell that will contain the formula
=SUMIF('Page 1'!C1:C53,"Total",'Page 1'!AS1:AS53)

Testing(2)TIME.xlsx

**kishoremcp** · 01-26-2012, 10:34 PM

It is still not working. I have changed the format of cells (AS1 to AS40) to h:mm:ss. After that tried to sum. But still getting 0 as the result.

**vlady** · 01-27-2012, 12:36 AM

OK. Here's what you should do.

Click Find and Replace. fastest way

Find : 00
replace all by : 0

Try it first to a copy of the original if it works you can apply it.
I've done it in your sample and it worked. I don't know if there are any 00 in your original file that can be affected. But in your sample there is none.

Cheers

: the time should be entered with one zero not two eg. 0:52:16 not 00:52:16