Description
Used to return valid time form time entered OR referred as text. Become very useful when used as an input for other nested EXCEL functions.
=TIMEVALUE(time_text)
The DATEVALUE function syntax has the following argument:
- Time_Text Required.
A text string that represents a time in any one of the Microsoft Excel time formats; for example, “6:45 PM” and “18:45” text strings within quotation marks that represent time.
