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

    calculation expression , display answer in as...

    Joanna Seldon



      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