Time format 1/1/1900 15:20:00

[CraigJ]

Hi,

I had some imported times in Access, some of theam are fine, but some of
them are like : 1/1/1900 15:20:00 , after copying them to excel they have
remained the same, and after apply number formats they are the same, I did
see a previous posting where you copy a value of 60 paste special, choose
divide , but this does not work as it is a time of day, not how many
minutes.

I am sorting the times using max, min etc and it is not sorting!

Thanks

 

[Bob Phillips]

Are you sure they have been imported as text?

Select the column, goto Data>Text To Columns, and just hit Finish, then
re-apply a time format.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)