'09:00AM trying to get remove the apostrophe

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

=TIMEVALUE(A1), Format as Time

--
Kind regards,

Niek Otten

"Kazza" <[email protected]> wrote in message news:[email protected]...
| 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