| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIMEVALUE - can I use cell reference as argument?
=--SUBSTITUTE(SUBSTITUTE(A1,"AM"," AM"),"PM"," PM")
"Steve Vincent" wrote: I need to convert a time that I import as text into military time. The time format is hh:mm:ssPM/AM (in other words, the times in text appear as 01:25:23AM , 02:34:11PM , 11:54:01AM , 03:51:13PM , etc. ). When I try to use TIMEVALUE, I get the #VALUE! error. It appears that the argument for TIMEVALUE must be in quotes. I have tried a number of methods to get TIMEVALUE to recognize the text time, but it never works (I have tried concatenating quote marks with the cell reference, etc.). This should be easy (one would think!) -- how can I convert this fairly straightforward text time into military time? I have searched this forum and have not found this specific issue addressed. Thanks in advance for any help you can offer. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| timevalue function | Excel Worksheet Functions | |||
| How do I enter a cell value into the Timevalue() function? | Excel Worksheet Functions | |||
| TimeValue formula | Excel Worksheet Functions | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| OFFSET using ADDRESS for the reference argument | Excel Worksheet Functions | |||
Threaded Mode
