If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
5 minutes intervals
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? |
#2
|
|||
|
|||
5 minutes intervals
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 |
#3
|
|||
|
|||
5 minutes intervals
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? |
Thread Tools | |
Display Modes | |
|
|