Converting text string to a its proper time format
Is all of your data AM, or does some of your data look like:
9:30p
In which case:
=TIMEVALUE(IF(RIGHT(A1,1)="a",SUBSTITUTE(A1,"a"," am"),SUBSTITUTE(A1,"p","
pm")))
Then change the cell format to a TIME format.
"Edmund Wong" wrote:
I have series of times in a column that is formatted as 9:30a, 9:40a,
etc. How do I convert these to time, i.e., 9:30 AM, etc.?
thanks
|