|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th 12, 07:04 AM
|
|||
|
|||
Averaging by half hour time intervals.
Hi all.
Working with quite a large amount of data which I have to condense from 2-3 second intervals into half hour averages. The timestamp is in column 1 with the form HH:MM:SS AM/PM (e.g 12:00:03 AM) and data of interest is in column 2. Only problem is that as it is an odd time interval, the half hour recording is not always the same time after the end of that period (e.g. not always 12:00:00, 12:30:00, 1:00:00 etc but rather say 12:00:03, 12:30:01, 1:00:02 etc) Any ideas? Any help would be most appreciated. -Nicholas 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I round time down to the nearest half hour? | KatJ | Excel Worksheet Functions | 3 | September 4th 09 01:54 AM |
| Convert Time To Half Hour - Pt 2 - OOPS! | BenS | Excel Discussion (Misc queries) | 4 | March 29th 07 09:52 PM |
| Convert time to Half Hour inverval | BenS | Excel Discussion (Misc queries) | 3 | March 29th 07 08:27 PM |
| How do i subtract a half hour from a time when >8 hrs. | lucy | Excel Programming | 3 | August 2nd 06 08:41 AM |
| Calculate time difference to the half hour | Ken Ivins | Excel Worksheet Functions | 6 | July 17th 05 05:48 PM |
Linear Mode
