10 Replies Latest reply on Mar 15, 2016 12:39 PM by steve.rodgers

    Calculate Time Difference in minutes and seconds....?

    steve.rodgers

      I need to calculate the time difference for datetime fields. I am close but need to show it in MM:SS, i have found some posts on calculating in minutes or seconds but not both. When I attempt to use minutes and divide by 60 it does not display correctly. Any help would be appreciated.

       

      I attached the workbook, the datediff function is not calculating the difference correctly for some reason?

       

      The first row should be 5 minutes and 8 seconds - (308 seconds).... not sure where I am going wrong.

      Time Formula.PNG