# TIMEVALUE

## Content

This function returns the TimeSpan object of the time represented by a text string.

## Syntax

`TIMEVALUE( time_string )`

## Arguments

Specify a time as a text string.

## Remarks

Use this function to convert a time represented by text to a TimeSpan object in the standard format. The time span is an amount of days, hours, minutes, and seconds.

## Data Types

Accepts string data. Returns a TimeSpan object.

## Examples

`TIMEVALUE(B18)`

`TIMEVALUE(R18C2)`

`TIMEVALUE("5:29")` gives the result 05:29.

`TIMEVALUE("5:29 PM")` gives the result 17:29.

`TIMEVALUE("17:29")` gives the result 17:29.