'09:00AM trying to get remove the apostrophe

K

Kazza

Probably an easy one for you all!

I have a long column of times (cell contents= '9:00PM ) extracted
from another application and I want to subtract another time from them. Is
there an easy way to convert this into a time that excel can use?

thanks
Kazza
 
N

Niek Otten

=TIMEVALUE(A1), Format as Time

--
Kind regards,

Niek Otten

| Probably an easy one for you all!
|
| I have a long column of times (cell contents= '9:00PM ) extracted
| from another application and I want to subtract another time from them. Is
| there an easy way to convert this into a time that excel can use?
|
| thanks
| Kazza
 
Top