Calculate downtime while some time ranges are excluded

Hello everyone,

I just created an account to ask for some help with an Excel sheet I am trying to prepare for work.
We maintain trains in operation, and are penalised whenever we have to stop one for repairs; except when these repairs occur between midnight and 5AM (between 00h00 and 05h00).

I've been trying to come up with a formula that, between 2 dates, would calculate the "downtime hours", that is, the total hours it has been under repairs minus the hours between 00h00 and 05h00.
(of course, if a repair stars and ends between 00h00 and 05h00, the "downtime hours" would be null).

I have attached an Excel file of what I'm looking for.

Thank you very much for your time.

All best,

one option which would replicate your expected results

Formula:

Please Login or Register  to view this content.

my bad -- modified:

Formula:

Please Login or Register  to view this content.

Originally Posted by XLent

my bad -- modified:

Wonderful, thank you very much XLent, you've been a lifesaver.