| 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! |
| 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 | |||
Threaded Mode
