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:
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:
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!