displaying correct cell value

G

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.
 
S

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
 
G

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
 
S

Sheeloo

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top