How to Use TIMEVALUE() in Google Sheets

Description

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

How To Actually Use TIMEVALUE() in Sheets

TIMEVALUE(time_string)

Try TIMEVALUE yourself

In cells B1:B10, you have time strings like '2:30 PM'. Use the TIMEVALUE function in cell C1 to convert the time string in B1 to a time value. Drag the formula down to fill C2:C10.

Your formula

Hints (2)

Locale Separator ,

Official Docs

1 Better Sheets Tutorial

Build a Visual Clock

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!

Intermediate

NOW() TIMEVALUE()

Transcript-matched member videos for TIMEVALUE(). Click through to watch.

Browse more tutorials

REGEXMATCH Formula Generator for Google Sheets

Revolutionize the way you handle data with the BetterSheets REGEXMATCHER...

Advanced

IF() REGEXMATCH()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

One Weird Google Sheet Formula for Bulk Publishing With AI

'll show you a game-changing Google Sheet formula that will make your da...

Intermediate

IF() ISBLANK() SUBSTITUTE()

Create a Trello Board with Transpose Formula in Google Sheets

Use Transpose() to create a web-based, Kanban style, list-making applica...