XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist


Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

The FormatSeconds Function


The FormatSeconds Function

If you have calculated (or been supplied) an elapsed time in seconds, then you can format that into a nicely legible format without having to divide by 60 for minutes, etc.

«FormatSeconds('3675','HH:mm:ss')» will render as “01:01:15”

Another example would be:

«ChooseUsingTimePicker(StartTime)»
«ChooseUsingTimePicker(EndTime)»
The time I spent was «FormatSeconds(SecondsBetween(EndTime,StartTime),'HH:mm:ss')»

You could make the resulting parts of the elapsed time more readable like this (assuming the data element ElapsedSeconds has the number of seconds):

The time I spent was «FormatSeconds(ElapsedSeconds, 'HH')» hours, «FormatSeconds(ElapsedSeconds, 'mm')» minutes and «FormatSeconds(ElapsedSeconds, 'ss')» seconds.