calculate downtime
I am looking for help. I would like to calculate the downtime of a machine in a column of a table for this I need the difference in minutes between the start time and stop time. The only exception is that the machine produces on working days from Monday to Friday from 6am to 11pm. so if the machine breaks down on Friday 10:50 PM and the fault is resolved on Monday 6:10 AM, 20 minutes of downtime must be calculated. I have tried everything but I cannot find the right combination of formulas. does anyone know if this is possible? example: Start: 9/1/2023 6:00:00 PM Stop: 9/1/2023 8:13:00 PM Result: 133 Start: 9/1/2023 9:15:00 PM Stop: 9/2/2023 8:13:00 PM Result: 105 Start: 9/3/2023 9:00:00 AM Stop: 9/3/2023 8:30:00 PM Result: 0 Start: 9/1/2023 10:15:00 PM Stop: 9/4/2023 8:00:00 AM Result: 165