Forum Discussion
Solved
Changing time only from 24hr to 12hr in a date time cell
How can I convert mm/dd/yyyy hh:mm:ss to mm/dd/yyyy hh:mm AM/PM? I do not want to change the date, only the time from 24hr to 12hr.
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.
7 Replies
- I have tried that but for some reason nothing changes.
Perhaps you have texts which looks like dates, not dates which are actually numbers.
