Extract all times from a textual value. Note that this includes specific times, times written in prose, and relative times, such as “tomorrow at 3pm”, “one hour from now”, etc.

Examples

EXTRACTTIMES("Set a meeting for November 14th at 4pm.") : 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 )

Arguments

text-to-extract-from (any textual)

Return Value

A list of Time values. 

See Also

EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTDURATIONS(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES()

Did this answer your question?