I come with a problem that has been raised by my manager, that I can solve in my head, but I cannot declare that in any way to excel formula language.
I have solved it but really not in the way It is supposed to be.
We have machines that may fail and breakdown, if it happens we register a ticket that declares the date and time that malfunction started.
As we know when malfunction stopped, and we have a specific breakdown time duration, we want to assign breakdown time to shift that was working at the time.
I solved this in the way I assigned the whole breakdown time to the shift that malfunction started, but the problem is I don't know how to split this time between more than one shift.
Let me give you an example:
We have 3 shifts working:
6-14 - Call it to shift A
14-22 - call it to shift B
22-6 - call it to shift C
If malfunction started at 12 and lasted for 16hours I have to assign breakdown time:
- A 2 hours
- B 8 Hours
- C 4 Hours
Magicians helping highly welcome, and appreciated.