how to use excel timevalue function

Quick Intro

If you want to convert a time value which is stored as a text you can use TIMEVALUE Function. It can convert a time which is in a textual format into a valid time.

When you refer to a text value, it will return a numeric value which excel can recognize as a valid time.



  • time_text A time which has formatted as a text which you want to convert into a valid time value.

More Information on Excel TIMEVALUE Function

  • You can provide a text format which excel can recognize.
  • It will convert text into a decimal number which represents time.


If you use a textual time value which has no am/pm in it, the function will return a serial number which represents time in 24-hour format. You can change format of serial number to get the time

Examples For Excel TIMEVALUE Function Simple TIme

Timevalue function will convert any textual time value which is recognizable by excel in the decimal number. As 12:00 AM is the starting time of a day, the function has return 0 for it.

Examples For Excel TIMEVALUE Function Full Time Value

Timevalue will return a decimal number ranging from 0 to 1 represents the time from 12:00 am To 11:59 pm.

Examples For Excel TIMEVALUE Function End Time

Timevalue is smart enough to get the time from a date if that date has time in it. While using timevalue function all you have to take care is, a textual date should be a date which can recognizable by excel.

Examples For Excel TIMEVALUE Function Date With Time

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel TIMEVALUE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have DATEVALUE function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.