9 Replies Latest reply: Jul 18, 2014 3:27 AM by Katleen Vercauteren RSS

    convert to time format

      I have calculated the interval between all the times I have in emptyings_time;

      emptyings_time is a time field.

      The interval has small values, mostly a minute or 2.

       

      This is my interval calculation:

      =below(emptyings_time,1)-(emptyings_time)

       

      In the pivot I selected time as format and that works perfectly, but now I want to use it in a chart.

      Where I can't select the time format, so I have to change it another way.

       

      Can anyone please help?