Skip to content
Excel

TIMEVALUE function in Excel

Converts a time in the form of text to a serial number

=TIMEVALUE(time_text)

TIMEVALUE syntax and parameters

One argument, one required.

  • time_textstringRequired

    A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.

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 Google Sheets

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 Excel gets this done.