Community room booking conflict calculator

Calculate booking conflict pairs and overlap minutes and available room gaps with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use booking conflict pairs and overlap minutes and available room gaps to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Bookings: name, start HH:MM, end HH:MM
A,10:00,11:00 B,11:15,12:00 C,14:00,15:00
Setup minutes before each booking
15
Clear-up minutes after each booking
15
Room opening time
09:00
Room closing time
17:00
Booking conflict pairs and overlap minutes
A/B: 15
Available room gaps
09:00–09:45; 12:15–13:45; 15:15–17:00
Total available room minutes
240
Bookings extending outside opening hours
0

Try another scenario

Bookings: name, start HH:MM, end HH:MM
A,10:00,11:00 B,11:15,12:00 C,14:00,15:00
Setup minutes before each booking
0
Clear-up minutes after each booking
0
Room opening time
09:00
Room closing time
17:00
Booking conflict pairs and overlap minutes
None
Available room gaps
09:00–10:00; 11:00–11:15; 12:00–14:00; 15:00–17:00
Total available room minutes
315
Bookings extending outside opening hours
0
Calculation method

Calculation method

Booking conflict pairs and overlap minutes

Expand each booking by setup and clear-up, then report pairwise positive overlap durations.

Available room gaps

Clip occupied blocks to opening hours, merge overlapping/touching blocks, and return the complementary gaps.

Total available room minutes

Sum complementary gap durations.

Bookings extending outside opening hours

Count expanded bookings crossing either opening boundary.

Symbols and units
a
Bookings: name, start HH:MM, end HH:MM
b
Setup minutes before each booking
c
Clear-up minutes after each booking
d
Room opening time
e
Room closing time

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A single-room, single-day interval audit with uniform setup/clear-up buffers. Shared endpoints are allowed after buffers. No bookings are moved or sent, and display clocks round fractional minutes.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

OpenStax: arithmetic and geometry ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.