EXTRACTTIMES()

Extract list of Time values within 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

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDURATIONS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

 

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false