array sorting with date and time

[christopherglasow]

Hi,

I'm looking for an efficient way to sort an array of data that has both date and time, I know I can sort date by converting to days, but looking for sorting the time in those days. I can think of soome solutions, but they are very inefficient. If any of you have any ideas I'd love your suggestions. 

Thanks
Chris

[tsh73]

convert date and time to floating point value
integer part is day from start of the days
fractional is (current second in a day) / (num of seconds in a day)
Then sort these numbers.
(with SORT command)

Excel does about the same, IMHO

Look at this
print date$()
print date$("days")       'day from start of the days, now
print date$("4/11/2002")  'same for given date
                         'note month is in the middle

print
print time$()
print time$("seconds")       '(current second in a day)
                            'should be ss+60*mm+60*60*hh
print time$("milliseconds")

print
t$="16:15:35"                'now with given time
print t$
hh=val(word$(t$,1,":"))
mm=val(word$(t$,2,":"))
ss=val(word$(t$,3,":"))
print hh,mm,ss
numDT=date$("4/11/2002")+(ss+60*mm+60*60*hh)/24/60/60
print numDT


[Rod]

If you hold your data as yyyymmddhhmmss you already have the job done.

[Brandon Parker]

Dec 9, 2023 11:10:04 GMT -5 Rod said:

If you hold your data as yyyymmddhhmmss you already have the job done.

Make sure to store the "hh" in military time... 00-23


{:0)

Brandon Parker