Biff:

Thanks! The Mod solution works, as I need to sort on the Time. And could not
by just changing the formatting. Now I can.

-b


"T. Valko" wrote:

Try this...

A1 = 12/15/2007 5:35 PM

To get the weekday in long name format (Saturday):

=TEXT(A1,"dddd")

To get the weekday in short name format (Sat):

=TEXT(A1,"ddd")

To get the time:

=MOD(A1,1)

Format as TIME

--
Biff
Microsoft Excel MVP


"Bman342" wrote in message
...
I receive a batch data feed with a date/time field in excel-compliant
format.
I would like to separate the Day (ie, Monday, Tuedsday, etc), and the Time
(8:00AM) into separate columns, and still show the Date in its own column.
I've done a =lookup on a =weekday function to get the day, and that works.
But how do I pull out the time? I've looked at different functions and
cannot
figure out how to do this. Any help would be appreciated.

-b