Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all!
I have a bench of meeting rooms reservation logs on one side (start time, end time).
I would like to know, for each time slot contained in an excel file, how many meeting rooms are booked.
I tried several solutions, but no idea how to go further.
I attached the log file, interval excel and qvw.
Thanks for your ideas.
Hub
Have you tried the interval match script command ?
Jonathan
See the attached my application
hope it helps you
Thank you both for your comment!
It really helped!
I had to put the time slots in the start_end time of booking interval, which I figured out after spending 2 hours trying to do the things in the opposite way
Once again, great! it works ! Thanks!