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

Are you sure they have been imported as text?

Select the column, goto DataText 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)

"CraigJ" wrote in message
...
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