| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying the correct value. | Excel Worksheet Functions | |||
| vlookup is returning a value one cell above the correct cell. | Excel Worksheet Functions | |||
| How can I blank a cell until a ref cell has the correct data? | Excel Discussion (Misc queries) | |||
| Only using the correct cell for the sum | Excel Worksheet Functions | |||
| Only using the correct cell for the sum | Excel Worksheet Functions | |||
Hybrid Mode
