=mod(a1,0)

will give you just the time. Adjust the range to suit.

--
Regards,
Fred


"Ugnz" wrote in message
...
I am importing data from a CSV which gives me a time with the appropriate
date. i.e. 8/11/07 11:51. I am only interested in the time portion of that,
as I'm adding my own data. When you type in a time, it automatically assumes
you mean 0/1/00.

How do I change the imported data to be the same date as my typed data,
given that the imported data will have several different dates?

Thanks

Maria :)