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

Did this answer your question?