Banding of timestamp or date into 5 min bands using excel - Visual Basic Snipplr Social Repository

Revision: 63854

at June 13, 2013 02:43 by mprabhuram

Initial Code

J2: =TIME(HOUR(B7),FLOOR(MINUTE(B7),5),0)
Where B7 contains Time Stamp

Initial URL

http://www.mrexcel.com/forum/excel-questions/359025-pivot-table-grouping-5-min-intervals.html

Initial Description

This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.

Initial Title

Banding of timestamp or date into 5 min bands using excel

Initial Tags

excel

Initial Language

Visual Basic