| 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? |
| 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 | |||
Threaded Mode
