TIMEVALUE(time_text) converts a time in the text to a serial number : TIMEVALUE « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. TIMEVALUE
Input the formula: =TIMEVALUE("2:24 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")