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.

 Averaging by half hour time intervals.
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Averaging by half hour time intervals.

 Thread Tools Display Modes
#1
May 15th 12, 07:04 AM
 nicholasfmccarthy Junior Member First recorded activity by ExcelBanter: May 2012 Posts: 1
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

 Thread Tools Display Modes Hybrid Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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

All times are GMT +1. The time now is 02:08 PM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.