Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

TIMEVALUE(time_text) converts a time in the text to a serial number

Input the formula: =TIMEVALUE("2:24 AM"). Press Enter to get the result.