Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display minutes ONLY and calc difference | Excel Discussion (Misc queries) | |||
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Is it possible to convert a number into hours and minutes | Excel Worksheet Functions | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions |