Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I have 1 column of call waiting times in the 00:00:00 format. When I use
the Custom filter it is not bringing up entries. I have a column heading name above my list and their are no blank rows. For example, if I want to sort all call waiting times that are over 4 secs, I turn on the AutoFilter on that column heading, select the Greater Than or Equal to option and select a cell that equals my criteria e.g. 00:00:04 This is the first time I'm sorting on time formats, does Excel not recognise this format in sorting?? I'm using V 2003. -- Regards Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting without changing formats | Excel Worksheet Functions | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Help with time formats | Excel Worksheet Functions | |||
Keeping Chart Series Formats whilst sorting | Charts and Charting in Excel | |||
Sorting and having cell formats stick with contents | Excel Discussion (Misc queries) |