Introduction to TIMEVALUE Function
TIMEVALUE function returns time after converting a text which represents a time into actual time. In simple words, it converts time into an actual time which is formatted as text.
Download Sample File
Download SAMPLE FILE to work, practice and master the TIME Functions in Excel.
Syntax of TIMEVALUE Function
TIMEVALUE(time_text)
Arguments of TIME Function
- time_text: A text which is a time value but stored as a text.
Example of TIME Function in MS Excel
We need to try it out in an example, so make sure to check out the below one:
If you use a textual time value that has no am/pm in it, the function will return a serial number which represents time in 24-hour format. You can change the format of the serial number to get the time.
TIMEVALUE will convert any textual time value which is recognizable by excel in the decimal number. As 12:00 AM is the starting time of the day, the function has return 0 for it.
It represents the time from 12:00 am to 11:59 pm. It’s smart enough to get the time from a date if that date has time in it. While using TIMEVALUE all you have to take care of is a date that can recognizable by Excel.
Other Excel Time Functions Tutorials
You can explore and master other Time functions in Microsoft Excel. Here is a complete list of Time functions available in Microsoft Excel.
