4 Replies Latest reply: Apr 18, 2016 10:55 AM by Joanna Seldon RSS

    differnce in temperatures - ignore nulls

    Joanna Seldon

      Hiya

       

      I need to work out time difference between one date time stamp and another.

       

      temperature of a room is taken on regular intervals during the day. This date time is recorded in the column, DateTimeTaken

       

      =interval(max({<Temperature={'>=35'}>} DateTimeTaken) - min({<Temperature={'<=35'}>}DateTimeTaken) ,'h:mm' )

       

      I need to calculate the time take for the room to reach 35.

       

      sometimes the Temperature column is not filled in ''null'

       

       

      please help