The TIMEVALUE function converts a time to a fraction of 1. Google Sheetsworks with timesas fractions of a number, not as text strings. This function converts times into their usable form. Noon would be .5 and 6 PM would be .75.

The function can be used with 12 hour AM/PM time or with 24 hour time. If a date and time is given to the function, the date will be ignored, but the time will be converted. To represent seconds, use a second colon. 5 minutes and 12 seconds would be "00:05:12" not "05:12".

Remember that dates are really justsaved as numbersby your spreadsheet with date formatting applied. The date must be in avalid format, so you have to use theDATE function, wrap it in quotes, or use a cell reference to a cell containing a date.



time_textText representation of a time.

Related functions

DATEVALUE- Converts a date to a numeric value in a similar way as TIMEVALUE.

HOUR- Returns the hour value from a time

MINUTE- Returns the minute value from a time

SECOND- Returns the second value from a time


#VALUE!- The inputs are something that isn't a valid time such as "A minute ago" or "Then".

#NUM- An input is a number but is not a valid time.


 Live examples in Sheets 

Go tothis spreadsheetfor the examples of the TIMEVALUE function shown above that you can study and use anywhere you would like.