1 2 Previous Next 20 Replies Latest reply on Jun 6, 2018 4:47 PM by Krishna Dudhela

    Calculating total in hh:mm:ss format

    Krishna Dudhela

      Hi Everyone,

       

      My requirement is to display time duration in hh:mm:ss format.

       

      In my attached workbook, you can see that I am able to calculate hh:mm:ss format. But when I total it(Column wise), it displays in hh:mm:ss format but the minutes and seconds exceeds 60.

       

       

      Can anyone tell me how can I correct this?

       

      Thanks,

      Krish.

        1 2 Previous Next