Meeting availability overlap
Find shared time windows from several people’s same-day availability.
A clear answer. Here’s how.
Uses minute-resolution intervals within one common day and time zone. Start is inclusive, end exclusive; end may be 24:00. Merges overlapping windows for the same trimmed, case-sensitive name. Finds maximal windows with at least the required number of the same people continuously available. Extra people joining or leaving do not split a valid window. Overnight windows must be split into separate days; time zones and calendar dates are not inferred.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- CSV: Person,Start,End (HH:MM)
Person,Start,End Ada,09:00,12:00 Sam,10:00,13:00 Jo,10:30,11:30
- Required participants (0 means everyone)
- 0
- Minimum continuous slot (minutes)
- 30
Example result
| Start | End (exclusive) | Minutes | Continuously available | Participants |
|---|---|---|---|---|
| 10:30 | 11:30 | 60 | 3 | Ada, Sam, Jo |
Maximal same-day windows with the listed people continuously available. Additional people joining or leaving do not split a valid slot.