| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making 5 Minute Wind Averages
Right now, I have data that is in 1 minute wind speed and direction (in
degrees) averages. I need to convert it to 5 minute averages (that is the average from time 0-5min, 6-10min, 11-15 min and so on). I've attempted to use the text and indirect functions to do this, but it ends up over lapping (i get averages from 0-5, then 5-9, then 9-13). What kind of code or functions can I write to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions | |||
| help with excel macros getting daily averages from 10 minute data | Excel Programming | |||
| help with macros for getting daily averages from 10 minute increment data - MS2000 | Excel Programming | |||
| help with macros for getting daily averages from 10 minute increment data - MS2000 | Excel Programming | |||
Threaded Mode
