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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort the teime of day in a tabe? 2
Countdown macro - display settings 2
Cannot sort a table containing text 5
I screwed up 0
Schedule meeting-same day with block time (e.g. 9-10am & 2-4 p.m) 1
Append Crosstab Query to Existing Table 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Blocking junk email 0

Top