8 Replies Latest reply: Jul 21, 2014 10:39 AM by Juan Lopez RSS

    Negative time

    Lukas Puschner

      Hello,

       

      I have a filed with positive and negative secconds.

      i want to have it in a time format. thats no problem for the positive values, but hot to make -120 secconds to - 00:02:00 ?

       

      time(Floor((ABW) / 3600) & ':' &  Floor(mod((ABW), 3600)/60) & ':' & mod((ABW) , 60),'hh:mm:ss')

       

      this is the code i have