Help with Formulas on time chart...

[tricialynn75]

I'm not sure about proper lingo.

I have a spreadsheet that an old Manager setup, which we are now having some problems with. FYI, there are 3 tabs on the sheet. One for the exported file, one for the actual Theatre Check Schedule and one for the setup information.

It's a chart to do Checks in Auditoriums every 40 minutes. We have a sheet that we export as an excel file which then calculates when we need to do each check per theatre. There are supposed to be at least 2 checks per show, however some shows run longer than others. Is there another way to set up the sheet to accurately make sure two checks are calculated for each auditorium?

Also, if we were to add the setup time, on the setup tab, to accomodate earlier or later shows the rows don't add up properly towards the bottom.

The sheet is divided into two sections. The top section is the Auditorium Checks and the bottom is set up for Bathroom Checks (Mens and Ladies) every hour. Which some of those formulas are not accurate.

Sorry, if this is confusing. If anyone could help it would be greatly appreciated. If there are any questions feel free to ask. I will do my best to answer.

Thanks,
Tricia