sortinging data from a specific point

[Guerilla]

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.

 

[RichardSchollar]

Hi

You could use a helper column with the following formula and sort
ascending based on the helper:

=MOD(TEXT(A1,"00\:00")-0.25,1)

Hope this helps!

Richard