ExcelBanter - '09:00AM trying to get remove the apostrophe

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - '09:00AM trying to get remove the apostrophe (https://www.excelbanter.com/excel-discussion-misc-queries/85012-09-00am-trying-get-remove-apostrophe.html)

Kazza

'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

Niek Otten

'09:00AM trying to get remove the apostrophe

=TIMEVALUE(A1), Format as Time

--
Kind regards,

Niek Otten

"Kazza" wrote in message ...
| 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

All times are GMT +1. The time now is 05:10 PM.