how do I paste in a time so that it is not formatted as text
I frequently paste data into calc that includes fields such as 00:01:30, 12:30:00 etc. These are recognized as text instead of times. They are left justified instead of right justified. I want them to be recognizes as times. If I select the column and change the format to time, it converts all the entries as text, with a '. This isn't what I want either. How can I set it so that times are automatically recognized as such, or how can I easily format the column as time, please?