Formulas > =TIMEVALUE()

How To Use TIMEVALUE() Function in Google Sheets


Returns the fraction of a 24-hour day the time represents.

Common Questions about the TIMEVALUE Formula:
What is the TIMEVALUE formula?
How do I use the TIMEVALUE formula?
What values can be used in the TIMEVALUE formula?

How can the TIMEVALUE Formula be used appropriately?
The TIMEVALUE formula can be used to convert text entries representing times, such as '6:30 am', into numerical values suitable for calculations, such as the decimal number 0.27083. Furthermore, it can be used to calculate times from numerical values, such as the amount of time (in hours) from 9.87.

How can the TIMEVALUE Formula be commonly mistyped?
The most common mistyping of the TIMEVALUE formula is missing out one of the parentheses. Unfortunately, when a formula is mistyped, Google Sheets often returns an error message such as “Invalid formula” or “Wrong Number of Arguments”.

What are some common ways the TIMEVALUE Formula is used inappropriately?
The TIMEVALUE Formula should not be used to convert dates into numerical values; a different formula is needed for this purpose. Additionally, it should not be used to compare numerical time values to text entries such as '6:30 am'.Finally, it should not be used with number formats other than the decimal format.

What are some common pitfalls when using the TIMEVALUE Formula?
The time values must always be written in the same format; 24-hour format or 12-hour AM/PM format. Additionally, it is important to correctly define the time zone as the time value will be converted to the time zone assigned.

What are common mistakes when using the TIMEVALUE Formula?
The most common mistake when using the TIMEVALUE Formula is to leave out the postfix which specifies the time format, such as ""AM"", ""PM"", or ""h"". Additionally, some users inadvertently try to enter a 24-hour time value as a 12-hour time value.

What are common misconceptions people might have with the TIMEVALUE Formula?
One common misconception is that the TIMEVALUE formula can be used to compare numerical values to text values. Another misconception is that the TIMEVALUE Formula can be used to convert dates into numerical values.

How To Actually Use TIMEVALUE() in Sheets


1Better Sheets Tutorial

I'll show you how to create a visual clock in your Google Sheet using conditional formatting. 

By following a few simple steps, you'll be able to see the progress of each hour throughout the day. 

No manual updates required! I'll guide you through setting up the custom formula, applying it to the desired range, and making it work for multiple columns if needed. 

Plus, I'll share a tip on how to reverse the colors if you prefer to track the remaining time instead. 

Let's get started and make your Google Sheet even more efficient! 

Learn more about the TIMEVALUE() formula:

Create an Employee Timesheet Using Google Sheets

Create a simple template for tracking employee time, including overnight shifts, with no coding. Google Sheets allows you to share your spreadsheet with other employees, and you can protect certain cells from others.

Generate a TIMEVALUE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.