I am sure this is an easy one, but I am at my wit's end trying to make work. Attached is some sample data, and what I am trying to do is consolidate information from 15 minute periods to 30 minute periods with a formula that can be used of the span of 24 hours. For example:
06/17/10 0600 2
06/17/10 0615 9
06/17/10 0630 16
06/17/10 0645 20
Consolidate the data so that it will read:
06/17/10 0600 11
06/17/10 0600 36
Any help is appreciated.
Thanks
Bookmarks