Sylviags

Posts: n/a

how do you format cells by time?

I am trying to sort times by earliest to latest on excel.
EX: I want this 8:30am-9:30am
9:45am-12:00pm
12:45pm-1:30pm
2:00pm-3:45pm

I have this 2:00pm-3:45pm
9:45am-12:00pm
8:30am-9:30am
12:45pm-1:30pm
I have them mixed up, but how do I format them to work in ascending order by
time??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time format	Oonagh	Excel Worksheet Functions	2	April 6th 05 03:08 PM
How do I get brackets in format cells accounting?	allan	Excel Discussion (Misc queries)	2	February 12th 05 10:08 PM
My sheet is unprotected, but I can't format cells.	Paul	Excel Discussion (Misc queries)	2	February 9th 05 11:20 PM
time format multiplied by hours worked ?	Brett	Excel Worksheet Functions	2	January 11th 05 01:11 AM
Subtracting time in date format	Collcat	Excel Worksheet Functions	1	November 10th 04 04:45 PM

All times are GMT +1. The time now is 12:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us