1 Reply Latest reply on Jul 25, 2017 6:53 AM by Zhouyi Zhang

    Formula to calculate the average time between two days excluding null or blank in HH:MM:SS

    Aqeel Bin Ishaq

      expert team,

       

      I am new in tableau community and want your to help me with figuring
      out about formula if possible. I need formula to calculate the average time
      between two days at the same time it take in consideration excluding the null
      or blank value if it is their ..Also I need the formula to show in HH:MM:SS format

       

      please help me with this …I have uploaded an excel sheet as a sample data.. please send me packaged workbook showing the formula if possible

       

      thank you very much