Time format
Im trying to sort a time column with data from a csv file. The column data from the csv file is in 12 hour format example below:
6:15-7:30 PM
11:00-Noon
7:00-8:30 PM
7:00-8:30 PM
9:00-10:15 AM
9:00-10:15 AM
10:15-11:30 AM
7:30-8:30 PM
3:00-4:00 PM
7:45-9:00 PM
5:30-7:00 PM
7:00-8:00 PM
9:00-10:30 AM
10:30-11:30 AM
7:30-8:30 PM
Noon-1:00 PM
5:00PM-6:00PM
7:00 PM-8:00PM
Noon-1:00 PM
Noon-1:00 PM
7:45-9:00 PM
Im having trouble with the results after sorting i.e. 6:00 - 7:00 PM follows 6:00 - 7:00 AM and so on. The text Noon is creating problems as well and ill have to change that.
I was hoping somoene could shed some light on this. Is it possible to change the data in my csv file to 24 hour format and then display it as 12 hour?
Or is there some other parameter i can use to specify the time format. I am a rookie when it comes to javascript so go easy.
6:15-7:30 PM
11:00-Noon
7:00-8:30 PM
7:00-8:30 PM
9:00-10:15 AM
9:00-10:15 AM
10:15-11:30 AM
7:30-8:30 PM
3:00-4:00 PM
7:45-9:00 PM
5:30-7:00 PM
7:00-8:00 PM
9:00-10:30 AM
10:30-11:30 AM
7:30-8:30 PM
Noon-1:00 PM
5:00PM-6:00PM
7:00 PM-8:00PM
Noon-1:00 PM
Noon-1:00 PM
7:45-9:00 PM
Im having trouble with the results after sorting i.e. 6:00 - 7:00 PM follows 6:00 - 7:00 AM and so on. The text Noon is creating problems as well and ill have to change that.
I was hoping somoene could shed some light on this. Is it possible to change the data in my csv file to 24 hour format and then display it as 12 hour?
Or is there some other parameter i can use to specify the time format. I am a rookie when it comes to javascript so go easy.
LOTL
June 8,