Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula to convert 15 minute to hourly data
I need a formula to convert 15 minute timestep data to hourly average (an
average of the four 15 minute data points for the hour). My spreadsheet looks like this: datetime in first cell data in second cell 1/1/00 00:00 2.2 1/1/00 00:15 2.0 1/1/00 00:30 1.9 1/1/00 00:45 2.0 1/1/00 01:00 2.4 1/1/00 01:15 2.2 1/1/00 01:30 2.1 1/1/00 01:45 2.0 1/1/00 02:00 1.8 etc..... I have about hundreds of rows of this type of data. At times there may be missing data, but the correct time is there, there is just no data in the cell. I would like a third column of data that would have the date/time at the top of the hour and the fourth column to have the hourly average. Any help appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert half hourly data into hourly | Excel Discussion (Misc queries) | |||
convert angle minute to decimal | Excel Discussion (Misc queries) | |||
How to convert an elapsed time in minutes to Days hours and minute | Excel Discussion (Misc queries) | |||
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 |