EXTRACTDURATIONS()

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

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
15871165318839291097
true
Search Help Center
true
true
true
false
false