| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping Times
Hi All,
I'm hoping this will be an easy answer, heres my query... 00:01 - 12:00 = 1, 12:01 - 18:00 = 2, etc etc A B 12:45 2 11:41 1 00:25 1 13:15 2 14:54 2 Now from the criteria above I would like column B to show 1's & 2's etc etc. Any ideas guys?? Thanks, James. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running a Macro a number of times | Excel Discussion (Misc queries) | |||
| sorting multiple minimum times | Excel Discussion (Misc queries) | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
Threaded Mode
