I have a interval ( date & time combined) coming out of imrpomtu via a save
to excel format as follows

In Impromptu it is in the follwoing format:

000 00:00:00.000
days hr, min, seconds, milla seconds


In excel I am getting the follwing in my columns:

10/25/05 13:50 ( visually in cell)

The format is custom m/d/yy h:mm

I need to get clean grabs of just the time in hours and minutes and just the
date

I can get the date out in text string so date is secondary in concern.

I need to do a great deal of time calcs , filters, and pivots - all on time

I also need to calc betwen dates with ands with out time.

Any suggestions on how to get this cleaned up into the best usable format
would be great - I do not mind extra fields.

thanks todd