Extract list of Duration values within textual value
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 astomorrow
,yesterday
,one hour from now
, and so on, as shown in samples above.
See also