HI April,

I assume that you dont want to merge any data here, just show every 5th entry.
If this is the case

=IF(MOD(MINUTE(C1),5)=0,"Show","")

Cell C1 contains your time. This will only display "Show" on every 5th
minute which you can then auto filter on.

HTH

Simon

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?

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via http://www.officekb.com