18 Replies Latest reply: Apr 9, 2017 2:46 PM by Oleg Troyansky RSS

    How to convert both int-values in labels of class-function to time format?

    Oleksandr Basanets

      Hi,

       

      I try to get a histogram (# instances of flights within some flight-length ranges).

       

      If I express mi flight length as int (number of minutes), I get what I want:

      demo1.PNG

      and I use class()-function:

       

      demo2.PNG
      However, I would like express minutes ranges as 'hh:mm - hh:mm'

       

      And closest what I can get is (by converting int-variable to 'hh:mm' variable) is next:demo3.PNG

      with:demo4.PNG

       

      I.e. it shows only left margin of bin, and do not show "-" sign for negative intervals.

       

      How can I get those labels looking like "02:30-03:00" and for negative: "-02:00 - -01:30"?