3 Replies Latest reply on Feb 28, 2016 7:32 AM by Shinichiro Murakami

    Calculate TurnAroundTime

    Jagjit Singh

      Hi All,

       

      I'm trying to calculate the time it takes to fill in a property based on the old tenant end date and the new tenant start date. I have got the calculation to give me the desired output but in certain cases I'm getting a negative value as highlight in the screenshot. I have attached the sample workbook and if you can let me know how to fix this please.

       

      TRTWrongValues.PNG

       

       

      Thanks

       

      Jag