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