| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging seconds
I am trying to figure out how to average a set of seconds to be used in a
graphing. Here is the data I have. Date ID Time May-05 4223 :40 Jun-05 4883 :26 Jul-05 1363 :24 Aug-05 286 :11 Sep-05 199 :10 Oct-05 2836 :09 Nov-05 1787 :09 Dec-05 2055 :10 Jan-06 2905 :12 Feb-06 2760 :32 Mar-06 2302 :31 Apr-06 1636 :19 May-06 1985 :10 Date ID Time May-05 11058 :21 Jun-05 12352 :25 Jul-05 9425 :17 Aug-05 10314 :13 Sep-05 6168 :08 Oct-05 4958 :09 Nov-05 4142 :09 Dec-05 3206 :10 Jan-06 4378 :12 Feb-06 4320 :12 Mar-06 5232 :15 Apr-06 4038 :18 May-06 4278 :14 I need to average the seconds for each ID #. I have used the custom format to make sure it is all in the [h]mm:ss format and I keep getting the #DIV/0! error. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Averaging seconds
Try
=AVERAGE(IF(B2:B200=4223,C2:C200)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ospreyguy" wrote in message ... I am trying to figure out how to average a set of seconds to be used in a graphing. Here is the data I have. Date ID Time May-05 4223 :40 Jun-05 4883 :26 Jul-05 1363 :24 Aug-05 286 :11 Sep-05 199 :10 Oct-05 2836 :09 Nov-05 1787 :09 Dec-05 2055 :10 Jan-06 2905 :12 Feb-06 2760 :32 Mar-06 2302 :31 Apr-06 1636 :19 May-06 1985 :10 Date ID Time May-05 11058 :21 Jun-05 12352 :25 Jul-05 9425 :17 Aug-05 10314 :13 Sep-05 6168 :08 Oct-05 4958 :09 Nov-05 4142 :09 Dec-05 3206 :10 Jan-06 4378 :12 Feb-06 4320 :12 Mar-06 5232 :15 Apr-06 4038 :18 May-06 4278 :14 I need to average the seconds for each ID #. I have used the custom format to make sure it is all in the [h]mm:ss format and I keep getting the #DIV/0! error. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Averaging seconds
I am still getting the #DIV/0! error... if I use =AVERAGEA(C2,G2) it gives me
0:00:00. All I want to know is if it took 21, 42, 35, and 51 seconds to do a specific task what is the average? But also keeing it in the colon format... "Bob Phillips" wrote: Try =AVERAGE(IF(B2:B200=4223,C2:C200)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ospreyguy" wrote in message ... I am trying to figure out how to average a set of seconds to be used in a graphing. Here is the data I have. Date ID Time May-05 4223 :40 Jun-05 4883 :26 Jul-05 1363 :24 Aug-05 286 :11 Sep-05 199 :10 Oct-05 2836 :09 Nov-05 1787 :09 Dec-05 2055 :10 Jan-06 2905 :12 Feb-06 2760 :32 Mar-06 2302 :31 Apr-06 1636 :19 May-06 1985 :10 Date ID Time May-05 11058 :21 Jun-05 12352 :25 Jul-05 9425 :17 Aug-05 10314 :13 Sep-05 6168 :08 Oct-05 4958 :09 Nov-05 4142 :09 Dec-05 3206 :10 Jan-06 4378 :12 Feb-06 4320 :12 Mar-06 5232 :15 Apr-06 4038 :18 May-06 4278 :14 I need to average the seconds for each ID #. I have used the custom format to make sure it is all in the [h]mm:ss format and I keep getting the #DIV/0! error. Any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Averaging seconds
You asked how to get an average per id. I showed how for one particular id.
Format has nothing to do with it just use a time format. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ospreyguy" wrote in message ... I am still getting the #DIV/0! error... if I use =AVERAGEA(C2,G2) it gives me 0:00:00. All I want to know is if it took 21, 42, 35, and 51 seconds to do a specific task what is the average? But also keeing it in the colon format... "Bob Phillips" wrote: Try =AVERAGE(IF(B2:B200=4223,C2:C200)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Ospreyguy" wrote in message ... I am trying to figure out how to average a set of seconds to be used in a graphing. Here is the data I have. Date ID Time May-05 4223 :40 Jun-05 4883 :26 Jul-05 1363 :24 Aug-05 286 :11 Sep-05 199 :10 Oct-05 2836 :09 Nov-05 1787 :09 Dec-05 2055 :10 Jan-06 2905 :12 Feb-06 2760 :32 Mar-06 2302 :31 Apr-06 1636 :19 May-06 1985 :10 Date ID Time May-05 11058 :21 Jun-05 12352 :25 Jul-05 9425 :17 Aug-05 10314 :13 Sep-05 6168 :08 Oct-05 4958 :09 Nov-05 4142 :09 Dec-05 3206 :10 Jan-06 4378 :12 Feb-06 4320 :12 Mar-06 5232 :15 Apr-06 4038 :18 May-06 4278 :14 I need to average the seconds for each ID #. I have used the custom format to make sure it is all in the [h]mm:ss format and I keep getting the #DIV/0! error. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula to convert time (3:46) to total seconds? | Excel Worksheet Functions | |||
| Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
| How do I sum increments of minutes and seconds | Excel Worksheet Functions | |||
| How do I convert 00:03:54 to get 234 seconds? | Excel Worksheet Functions | |||
| convert seconds to minutes and seconds | Excel Worksheet Functions | |||
Linear Mode
