Skip to main content

Duration.FromText

Returns a duration value from textual elapsed time forms (d.h:m:s).

Syntax​

Duration.FromText(
    text as text
) as duration

Remarks​

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.

Examples​

Example #1​

Convert <code>"2.05:55:20"</code> into a <code>duration</code> value.

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

Result:

#duration(2, 5, 55, 20)

Category​

Duration