FormatDuration

The FormatDuration function converts a duration in seconds into a formatted date/time string.

Syntax


String= FormatDuration(Seconds)

Parameters

This function has the following parameter.

Table 1. FormatDuration function parameters
Parameter Format Description
Seconds Integer Number of seconds.

Return Value

Formatted date/time string.

Example

The following example shows how to convert the seconds from the GetDate function into formatted date/time strings.


FormatDuration(GetDate() - int(VALUE))