Duration.FromText

Syntax

Duration.FromText(text as nullable text) as nullable duration

About

Returns a duration value from the specified text, text. The following formats can be parsed by this function:

  • (-)hh:mm(:ss(.ff))
  • (-)ddd(.hh:mm(:ss(.ff)))

(All ranges are inclusive)

  • ddd: Number of days.
  • hh: Number of hours, between 0 and 23.
  • mm: Number of minutes, between 0 and 59.
  • ss: Number of seconds, between 0 and 59.
  • ff: Fraction of seconds, between 0 and 9999999.

Example 1

Convert "2.05:55:20" into a duration value.

Usage

Duration.FromText("2.05:55:20")

Output

#duration(2, 5, 55, 20)