Posted to microsoft.public.excel.programming

Peter[_28_] Peter[_28_] is offline

external usenet poster

Posts: 60

Date & time question

Hi,

I have a spreadsheet that has the date & time in the same cell, in the
format:

dd/mm/yy hh:mm

Is there a method of easily separating the date and time into two
different columns? Unfortunately there are over 300 hundred cells in a
column that need to be sorted.

--
Cheers

Peter

Please remove the invalid to reply

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
Date & Time Question	sot	Excel Discussion (Misc queries)	7	October 30th 07 06:43 PM
Time and Date Question	wx4usa	Excel Discussion (Misc queries)	6	October 8th 07 03:34 AM
Date Time Question	srroduin	Excel Programming	3	May 24th 06 05:32 PM
Date/Time Question	bladelock	Excel Worksheet Functions	2	November 10th 05 02:42 AM
date/time question	mk	Excel Programming	5	June 7th 05 12:32 PM

All times are GMT +1. The time now is 02:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us