displaying correct cell value
 

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.

displaying correct cell value
 

=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" wrote:

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.

displaying correct cell value
 

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" wrote:

=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" wrote:

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.

displaying correct cell value
 

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


"GAIDEN" wrote:

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" wrote:

=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" wrote:

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.

displaying correct cell value
 

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

"GAIDEN" wrote:

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" wrote:

=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" wrote:

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.