Quote:
Originally Posted by cuartetto
In column B I have 1000 time entries with the following format. 9:30AM,
10:30PM. I would like to move the AM or Pm into a new column. I've tried
"fixed width", also tried changing the format to put a space between the time
and the AM/PM, but nothing has worked.
Any suggestions?
Don
|
Let's say that cell A1 has 10:30PM.
In cell A2, you should have:
=(LEFT(A1,LEN(A1)-2)&" "&RIGHT(A1,2))*1
Then format the cell in Time 13:30 format.
In cell A3, you should have:
=Right(A1,2)