Thanks ScottPletcher,

I'll have a look at that.

That was where I was ultimately hoping to get to because as you say we do have bookings to the 5 minutes.

Andy

Thanks for replying as1981,

The reason it is 5.5 hours is because there is a 1 hour overlap (10-11) where two bookings are in the same room at the same time,...

Hi pietlinden

Because we only want to calculate occupancy from 08:30 -16:00, (even though some meetings actually start at 08:00 - don't ask!!:-))

I've looked at your code (which was extremely useful!!)...

Thank you pietlinden!

I will try that asap.

The expected results based on the example I've given would be:

ROOM        DATE              OCCUPANCY (HRS)

A                   22/11/19          5.5

B                   22/11/19          6

A                   23/11/19           4

B                   23/11/19            7.5

Also, apologies for the way...

• This reply was modified 4 years, 9 months ago by  Steve Jones - SSC Editor. Reason: code formatting

Thanks for the reply Ian,

I'll try that.

Thanks for the replies folks.

For 15 years I worked on querying, writing views and reporting from various servers. This is without any knowledge of administrating the database.   

Thanks Thom.

That it really helpful.