EXTRACTDURATIONS()

Returns a list of Duration values within textual value.

Sample usage

EXTRACTDURATIONS("noon to 4p")  returns  04:00:00  (list of one item).

EXTRACTDURATIONS("Monday to Friday")  returns  96:00:00  (list of one item).

EXTRACTDURATIONS("From November 10th to November 12th")  returns  48:00:00 (list of one item).

EXTRACTDURATIONS("Jan 1 to Feb 1") returns  744:00:00 (list of one item).

EXTRACTDURATIONS("Thursday at 10:27 to Sunday at 16:15")  returns  77:48:00 (list of one item).

Syntax

EXTRACTDURATIONS( text-to-extract-from )

• text-to-extract-from  - Any textual value. 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 , and so on, as shown in samples above.

See also

Date and time expressions

EXTRACT()

EXTRACTCHOICE()

EXTRACTDATES()

EXTRACTDATETIMES()

EXTRACTDOMAINS()

EXTRACTEMAILS()

EXTRACTHASHTAGS()

EXTRACTMENTIONS()

EXTRACTNUMBERS()

EXTRACTPHONENUMBERS()

EXTRACTPRICES()

EXTRACTTIMES()