How do I sort the time of day in a tabe?

S

sue

I am trying to sort the first column of my table by time of day, a.m. and
p.m. but can't figure it out.
 
R

Rae Drysdale

I assume you have a.m. and p.m .after your times. When I sort by Date it
works when there are no periods in the am and pm but a space between the time
and the am, ie 5.00 pm rather than 5.00 p.m. or 5.00pm. Does this work for
you?
 
Top