Forum Discussion
Changing time only from 24hr to 12hr in a date time cell
Depends on how data is structured, but in general by formulas.
One variant, select column with such texts, Data->Texts to Columns, on second step is Space as delimiter
on third step Date for first column with MDY
Sum received columns in another one, copy result and Paste as values, apply any desired format.
That's okay if in source column in some cells will be texts (e.g. headers), above affects them if only texts have space inside. When also will be split.
Perhaps you have texts which looks like dates, not dates which are actually numbers.
- You are probably correct. How do I change that?
Depends on how data is structured, but in general by formulas.
One variant, select column with such texts, Data->Texts to Columns, on second step is Space as delimiter
on third step Date for first column with MDY
Sum received columns in another one, copy result and Paste as values, apply any desired format.
That's okay if in source column in some cells will be texts (e.g. headers), above affects them if only texts have space inside. When also will be split.
- Thanks Sergei. That solved my issues.