Examples
EXTRACTDURATIONS("noon to 4p")
: 04:00:00
(list of one item)
EXTRACTDURATIONS("Monday to Friday")
: 96:00:00
(list of one item)
EXTRACTDURATIONS("From November 10th to November 12th")
: 48:00:00
(list of one item)
EXTRACTDURATIONS("Jan 1 to Feb 1")
: 744:00:00
(list of one item)
EXTRACTDURATIONS("Thursday at 10:27 to Sunday at 16:15")
: 77:48:00
(list of one item)
Syntax
EXTRACTDURATIONS( text-to-extract-from )
Arguments
text-to-extract-from (any textual): Includes spans of time between specific dates and times, spans of times written in prose, and relative dates and times, such as “tomorrow”, “yesterday”, “one hour from now”, etc. See examples.
Return Value
A list of Duration values.
See Also
EXTRACT(), EXTRACTCHOICE(), EXTRACTDATES(), EXTRACTDATETIMES(), EXTRACTEMAILS(), EXTRACTHASHTAGS(), EXTRACTMENTIONS(), EXTRACTNUMBERS(), EXTRACTPHONENUMBERS(), EXTRACTPRICES(), EXTRACTTIMES()