How do I get rid of milliseconds from a whole column of data in Excel?

Kim Walker September 3, 2012
Pinterest Stumbleupon Whatsapp

I have been trying and trying to get milliseconds removed from a time stamp in a column of data and I can’t do it. The time is in military time that looks like this:

12:32:01:.6240
12:32:01:.6339
12:32:01:.7249
12:32:02:.7259

And there is another column in another spreadsheet that I need to compare the time stamps to, but it does not have the milliseconds. It just looks like this:

8:00:51
8:00:51
9:02:06
9:02:06
9:20:26

I have tried writing a macro, everything I know how to do, but I can’t get it to change the whole column. It puts PM in the formula bar. It only changes one at a time. And there is 23K+ rows of data, so I can’t do it one by one. Please help!

Thanks,
Kim

Ads by Google

Ads by Google