TIMEVALUE Function To Convert Text Into Time
DEFINITION: TIMEVALUE Function Converts A Valid Time Stored As Text In A Cell Into A Excel Valid Time In A Serial Number Format. From 0 (12:00:00 Am) To 0.99988426 (11:59:59). Set The Format As Time To Convert Serial Number Into A Time Value.
SYNTAX : =TIMEVALUE (VALID TIME_TEXT)