displaying correct cell value

[GAIDEN]

COLUMN A COLUMN B COLUMN C COLUMN D

Start Date Agent Total Calls Total Talk Time

Row 3 11/10/2008 2011 78 02:56:12

Row 4 11/10/2008 2012 89 02:42:34


I'm trying to create a formula that displays the "Total Talk Time" for each
"Agent" on a separate work sheet.

 

[Sheeloo]

=Sumproduct (--($B$1:$B$100=T1),($D$1:$D$100))
will give you the sum of total talk time for Agent 2011 if T1 contains 2011

 

[GAIDEN]

thanks,

now, how can i add up the times and have it show the total time. i.e. if the
times added up to 26 hrs 4 min and 13 secs it would display 26:04:13

 

[Sheeloo]

Multiple by 24 - the integer part will give you hours...
Multiply decimal part by 60 to get minutes

 

[Shane Devenshire]

Hi,

Since the original times look like real times entered as 2:04:15 all you
need to do is format the total cell to

[h]:mm:ss

If this helps, please click the Yes button,

Cheers,
Shane Devenshire