EXTRACTTIMES()

Extract list of Time values within a textual value

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()

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
1515206464958585296
true
Search Help Center
true
true
true
false
false