Return to Snippet

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