Seconds

seconds(value, round(optional boolean))

The seconds function accepts a decimal value (measured in hours) and returns the number of whole seconds. The round parameter is optional (defaults to true for seconds) and determines if the number of seconds is rounded.

seconds(4.5) will return 0

seconds(4.67773,0) will return 39 (truncated to a whole number of seconds)

seconds(4.67773) will return 40 (rounded by default)

The seconds function is normally used with the hours function and the minutes function.

The seconds function is also useful for situations involving degrees, minutes and seconds of arc