3 Replies Latest reply on Jul 11, 2017 6:33 AM by Michael Gillespie

    Status analysis start and end date overlap month

    Boy Beng Tjoe Tjoa

      Hi Community,

       

      I have a question surrounding status changes. I have data for a room status eg:

       

      StatusStart Date & TimeEnd Date & Time
      A20/06/17 00:0010/07/17 14:01
      B10/07/17 14:0111/07/17 18:00

       

      I want to know the hours spend in Status A and B for June and July. I create a calculated field to calculate the elapsed time but how do I split the data over the different months?

      If I use the start date all the hours are booked in the start month and if I use the end date all the hours are booked in the end month.

       

      Can somebody help me?

      Thanks,

      Boy