I need to extract out the time, convert to time in 24 hour format and then use it to sort a report by time. The time needs to sort chronological order. Not in number value order. 1 pm (etc) comes after 12 noon on.
- Using this expression:
- Realtime: CStr(Format(CDate(Left([Start Time],2) & ":" & Right([Start Time],2)),"h:nn AM/PM"))
- Original data: 10:45 a.m., 101 Oregon Hall
- results are: 10:45 AM
- Original data; 12:15 p.m., 101 Oregon Hall
- results are correct; 12:15 PM
- Original data: 1:45 p.m., 101 Oregon Hall
- results are #ERROR