Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I need to sort data using one column which contains time (not in time format - in number format specific to four characters "0000" - this is to speed up input by the user). The working day starts at 0600 so the column will need to be sorted in ascending order starting at 0600. The data before 0600 i.e. from 0000 to 0559 then needs to appear at the bottom of the series of data. so, the column should go from 0600 to 0559. any help greatly appreaciated. kind regards, Matt PS - I use a function to convert the 0000 format to time 00:00 to analyse time queries. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Extract specific data into its own workbook via macro? | Excel Discussion (Misc queries) |