The FormatSeconds Function

April 5, 2016 User Reference

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 […]

Read the full article →