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