I try to calculate downtime for machines. I know starting time and ending time for repairing works.
But problem is that there can be multiple repairing works same time for same machine. I should not sum simultaneous repairing times.
Is it possible to make a formula that sums repairing time only once if there is simultaneous repairing works for same machine?
But problem is that there can be multiple repairing works same time for same machine. I should not sum simultaneous repairing times.
Is it possible to make a formula that sums repairing time only once if there is simultaneous repairing works for same machine?