Extract list of Time values within a textual value
Returns a list of Time
values within the textual value. Includes specific times, times written in prose, and relative times, such as “tomorrow at 3pm”, “one hour from now”, and so on.
Sample usage
EXTRACTTIMES("Set a meeting for November 14th at 4pm.")
returns 4:00:00 PM
(list of one item).
EXTRACTTIMES("Set a meeting for tomorrow at 4pm.")
4:00:00 PM
(list of one item).
Syntax
EXTRACTTIMES(text-to-extract-from)
text-to-extract-from
- Any textual value.
See also