Calculating Assessible Outage Times During a Window of Time.

Samino

New Member
Joined
Jan 29, 2014
Messages
1
The time between Each Arrival (X) and Departure (Y) is dwell time.

The dwell time needs to be checked against a list of Outage Start (A) and Outage End (B) times.

The dwell time can be excused in portion or entierly if there is an outage time for the same period. There can be multiple seperate outage times within a dwell time.

ie.
Item arrives at 10:00am and departs at 11:00am
Outage windows are
0900-0906
0950-1005
1015-1020
1056-1120

In this case

0900-0906 (not valid - out of dwell period)
0950-1005 (5 minutes from 1000 to 1005 is valid)
1015-1020 (5 minutes from 1015 to 1020 is valid)
1056-1120 (4 minutes from 1056 to 1100 is valid)

The result should be 14 minutes of outage time during the 1 hour period of dwell.

Essentially there is a list of Dwell times to be compared to the list of outage times and must do this for the entire list.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,708
Messages
6,174,006
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top