April,

could you post a bit more detail, with examples of what your data looks
like? I have a feeling you want to show a range like 0-4, 5-9, 10-14
etc in one column so you can sort by these ranges, but Simon has taken
a different interpretation of what you want.

Pete

April wrote:
I have a column that is sorted by time & date in one min. intervals. I need
it to show me the time in 5 min. intervals. Obviously excel can do this I
just can't figure it out, any suggestions?