EXTRACTTIMES()

Returns a list of Time values within the textual value. Includes specific times, times written in prose, and relative times, such as “tomorrow at 3pm”, “one hour from now”, and so on.

Sample usage

EXTRACTTIMES("Set a meeting for November 14th at 4pm.") returns 4:00:00 PM (list of one item).

EXTRACTTIMES("Set a meeting for tomorrow at 4pm.") 4:00:00 PM (list of one item).

Syntax

EXTRACTTIMES(text-to-extract-from)

• text-to-extract-from - Any textual value.

See also

Date and time expressions

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()