Excel TIMEVALUE Function

HomeExcel FunctionsExcel TIMEVALUE Function (Example + Sample File)


The Excel TIMEVALUE Function is listed under Microsoft Excel's Time Functions category. It 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.

How to use it

To learn how to use the TIMEVALUE function in Excel, you need to understand its syntax and arguments:




  • time_text: A text which is a time value but stored as a text.


  • You can provide a text format that Excel can recognize.


To master the TIMEVALUE function 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.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.