1 Reply Latest reply on Sep 18, 2018 10:42 AM by Deepak Rai

    how to Sum hh:mm:ss

    Olyvia Nguyen

      Hello team,


      I'm working on a report that shows the number of time that we saved from our tasks. Lets say the task is supposed to take no longer 30 minutes and we took 15 minutes to finish it, so we saved 15 minutes. so what I used is 30 - DATEDIFF('minute', [starttime], [endtime]) and then it'll sum it up.

       

      I read somewhere that I must have it in seconds and then format it to HH:MM:SS, but I can not sum it up if its in that format.