# FormatDuration

{% hint style="info" %}
The **`Formatduration()`** function converts a <mark style="color:blue;">duration</mark> to <mark style="color:green;">text</mark> according to the provided format.

This function is NOT SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/~/changes/y5gAfiyi2fILzrLzUUHj/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns a new <mark style="color:green;">text</mark> string that is the text representation of a duration. \
Returns <mark style="color:red;">`Invalid expression`</mark> if<mark style="color:blue;">`number`</mark>is unknown or the indicated format is not valid for duration. &#x20;
{% endhint %}

### Syntax

<details>

<summary><code>FormatDuration(</code><mark style="color:blue;"><code>duration</code></mark><code>,</code><mark style="color:blue;"><code>format</code></mark><code>)</code></summary>

`FormatDuration('3d4h17m30s', "hh")`\
\=> 04

</details>

<details>

<summary><code>FormatDuration(</code><mark style="color:blue;"><code>duration</code></mark><code>,</code><mark style="color:blue;"><code>language</code></mark><code>)</code></summary>

`FormatDuration('2d3h21m54.87s', currentlanguage)`\
\=> 02:03:21:54.87

</details>

### Parameters

<table><thead><tr><th width="150">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>duration</code></mark></td><td>date time </td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>a duration, in minutes, hours or seconds.</td><td>yes</td></tr><tr><td><mark style="color:blue;"><code>format</code></mark></td><td>numeric</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>the format is used to specify how the duration should be represented. You can find the different formats below. </td><td></td></tr><tr><td><mark style="color:blue;"><code>language</code></mark></td><td>yes/no</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>this parameter is used to specify the time representation of that language. If the language parameter contains an unknown value, the default portal language is used to format the duration.</td><td></td></tr></tbody></table>

{% hint style="info" %}

The `format` parameter can contain a number of WEM specific options:

* days - returns the total number of days in the `duration`
* hours- returns the total number of hours in the `duration`
* minutes - returns the total number of minutes in the `duration`
* seconds - returns the total number of seconds in the `duration`
* long - returns the duration as a written string, based on the portal language
* stopwatch - returns the duration formatted as follows: `(hours):(minutes):(seconds)`
* clock - returns the duration formatted as follows: `(hours):(minutes)`

You can also use the \[Microsoft format strings]\(<https://msdn.microsoft.com/en-us/library/ee372287(v=vs.110).aspx> ) to format the duration.
{% endhint %}