4 Replies Latest reply: Nov 5, 2015 5:56 AM by Joanna Seldon RSS

    calculation expression , display answer in as...

    Joanna Seldon


      Hiya

       

      I have a an time expression calculation

       

      interval(avg(ShoppingTime)/1440,'h:mm') - interval(avg(ActualShoppingTime)/1440,'h:mm')

       

      I wish to if the answer is a minus, just show 00:00:00 and not e.g - 01:00:00

       

      is this possible please