To Hours, Minutes, Seconds

To return a length of seconds in Hours:Minutes:Seconds format, use the To Hours, Minutes, Seconds data function in the Query section.

  1. In Query section, select Query menu, select Add Computed Item and name the new data item in the dialog box.
  2. In the panel, type To_HHMISS followed by a left parenthesis
  3. Next, use the Reference button to select Seconds data element from the table and type a right paren.
  4. Click OK in the Item dialog box.
  5. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013