4 Replies Latest reply on Oct 3, 2018 2:23 PM by Joe Oppelt

    Need help on a LOD calculation

    kate summer

      Hi,

       

      I am working on room usage report. I want to calculate total minutes booked in weekdays and weekends. In the sample workbook attached, event 1 has two sections that take place in the same room, on the same day of the week and at the same time period, it should be counted once (170 mins usage).  The result I am looking for is as below.

       

      Facility Id      Total_Weekend_Mins    Total_Weekday_Mins

      CD-134                   180                   1,155

       

                

      Facility IdTotal_Weekend_MinsTotal_Weekday_Mins
      CD-1341801,155

      Thank you for any help!

       

      Kate