Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Hi all, i have an issue with large amount of data...all data contain a time
cell and i want to group the times in intervalls of 24 Hrs devided by 4. As an example group 1 = 00:00 - 06:00 group 2 = 06:00 - 12:00 group 3 = 12:00 - 18:00 group 4 = 18:00 - 24:00 the data is something like this: 00:18 01:29 18:55 Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Peter,
You can create the group by using a formula based on the time: for time in cell A2, use =INT(A2*4)+1 and then copy down. This will put 06:00 into group 2, not into both. HTH, Bernie MS Excel MVP "Peter" wrote in message ... Hi all, i have an issue with large amount of data...all data contain a time cell and i want to group the times in intervalls of 24 Hrs devided by 4. As an example group 1 = 00:00 - 06:00 group 2 = 06:00 - 12:00 group 3 = 12:00 - 18:00 group 4 = 18:00 - 24:00 the data is something like this: 00:18 01:29 18:55 Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Thanks a lot Bernie, this helps a lot!
"Bernie Deitrick" wrote: Peter, You can create the group by using a formula based on the time: for time in cell A2, use =INT(A2*4)+1 and then copy down. This will put 06:00 into group 2, not into both. HTH, Bernie MS Excel MVP "Peter" wrote in message ... Hi all, i have an issue with large amount of data...all data contain a time cell and i want to group the times in intervalls of 24 Hrs devided by 4. As an example group 1 = 00:00 - 06:00 group 2 = 06:00 - 12:00 group 3 = 12:00 - 18:00 group 4 = 18:00 - 24:00 the data is something like this: 00:18 01:29 18:55 Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Time
Excel 2007 Pivot Table
Good for odd/unequal time/sequence intervals. Automatic interval headers and grouping. http://www.mediafire.com/file/jmtleqdwgzz/06_09_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate the average time from a group of TIMES in excel | Excel Discussion (Misc queries) | |||
Group a set of 'time' | Excel Worksheet Functions | |||
Group Time | Excel Discussion (Misc queries) | |||
TWO FILES OPEN AT SAME TIME XLS:1 AND XLS:2 GROUP??? | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |