=TIMEVALUE("22-Aug-2008 6:35 AM") : TIMEVALUE « Date Time functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =TIMEVALUE("22-Aug-2008 6:35 AM"). Press Enter to get the result.
15.13.TIMEVALUE
15.13.1.TIMEVALUE(time_text) converts a time in the text to a serial number
15.13.2.=TIMEVALUE("22-Aug-2008 6:35 AM")