Skip to content
Google Sheets

TIMEVALUE function in Google Sheets

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

=TIMEVALUE(time_string)

TIMEVALUE syntax and parameters

One argument, one required.

  • time_stringstringRequired

    The string that holds the time representation.

TIMEVALUE examples

Formulas you'll actually reuse.

  1. A text time as a fraction of a day — 17:15 is 0.71875, so multiply by 24 for hours:

    =TIMEVALUE("17:15")

    Result0.71875

  2. Hours between two clock times that arrived as text:

    =(TIMEVALUE("5:15 PM") - TIMEVALUE("8:30 AM")) * 24

    Result8.75

TIMEVALUE in Excel

Same name — your formula ports as-is.

Try TIMEVALUE in the playground

Edit the example — nothing to install.

Preloaded with the TIMEVALUE formula from Example 1 — change anything and watch it respond.

Loading the editor…

TIMEVALUE errors

What they mean — and the fixes.

  • #VALUE!

    The text isn't a recognisable time — check for a stray date, a missing colon, or 24:00 written as 24:00:00.

Related functions

More ways Google Sheets gets this done.