TIMEVALUE Function in Google Sheets

Convert a time string to a time value in Google Sheets using the TIMEVALUE function.

TIMEVALUE Function

The TIMEVALUE function in Google Sheets is used to convert a time string into a serial number that represents a specific time of day.

Syntax

TIMEVALUE(time_string)
  • time_string: The time string to be converted into a time value.

Examples

  1. Convert Time String to Time Value

To convert the string "14:30:00" to a time value:

=TIMEVALUE("14:30:00")
  1. Using Cell Reference

If cell A1 contains "09:45:00", you can convert it using:

=TIMEVALUE(A1)

Notes

  • The returned value is a decimal number between 0 and 1, where 0 represents 12:00:00 AM and 1 represents 11:59:59 PM.
  • This function is useful for performing calculations with time data.
  • DATEVALUE: Converts a date string into a date value.
  • NOW: Returns the current date and time.