TIMEVALUE

The TIMEVALUE function in Google Sheets converts a time given as text into the fraction of a 24-hour day it represents, producing a serial time value that Sheets can use in calculations. It's the time-only counterpart to DATEVALUE. Dive into our comprehensive guide to master its application.

Parameters

• time_string: A text string representing a time, such as "6:30 PM" or "18:30:00".

Step-by-Step Tutorial

1. Converting a time string to a serial value:

   • Example: =TIMEVALUE("6:00 PM")
   • Result: 0.75 (three-quarters of a day)

2. Formatting the result as a time:

   • Example: =TEXT(TIMEVALUE("6:00 PM"), "HH:MM:SS")
   • Result: 18:00:00

Use Cases and Scenarios

1. Data Import Cleanup: Convert time values stored as plain text into usable numeric time values.
2. Scheduling Calculations: Compare or calculate durations between text-based time entries.
3. Time Arithmetic: Combine TIMEVALUE with DATEVALUE to reconstruct full date-time values from separate text fields.

Related Functions

• DATEVALUE: Converts a date string into a date value.
• TIME: Converts hour, minute, and second into a time value.

Related Articles

• Normalize Dates with DATEVALUE and TEXT in Google Sheets