| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
'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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| how do i remove hyphens from between numbers | Excel Worksheet Functions | |||
| Remove leading Numbers from text | Excel Worksheet Functions | |||
| how to remove "(All)" in a pivot table using VBA | Excel Discussion (Misc queries) | |||
| Remove Hyperlink | Setting up and Configuration of Excel | |||
Linear Mode
