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

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


      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