Forum Discussion
Formula Assistance Needed
Left all your columns/formulae in place, but added 22 (!!) helper columns (grouped J:AF) with the end result in AF. The first six columns restructure the dates and time a bit so that it becomes easier to calculate with. Then I do a range of tests that are needed to calculate the overlap of down-time and working hours.
Not very elegant, but still manageable. And I couldn't think of a better way to do it.
Yeah both of us working on the same excel together actually.
Sorry for the confusion.
I have cleared most of the problems on the sheet. Attached for your reference.
Understood that there will be a problem if the value goes negative for Operation Downtime Duration column. Is there any other method that we can try with ? Else then I guess we should calculate it manually and state it.
Kindly advise, please.
Thank you.
Left all your columns/formulae in place, but added 22 (!!) helper columns (grouped J:AF) with the end result in AF. The first six columns restructure the dates and time a bit so that it becomes easier to calculate with. Then I do a range of tests that are needed to calculate the overlap of down-time and working hours.
Not very elegant, but still manageable. And I couldn't think of a better way to do it.
Great to have your guidance and assistance! I did tried cross-checking the output, there is several invalid / wrong outputs shown. For example : Station 12671 & Station 8749. Downtime outside the working hours is still being shown.
Is it due to the date and time range ? But on other dates or on other stations mostly the data is valid.
Attached for your reference. Kindly assist to advise, please.
