I have 5 sets of start timestamp and end timestamp. I also have 5 sets of stop timestamp & restart timestamp which can occur between the start & end timestamps. I need to create a net cycle time report, which basically is below:
networkdays(start timestamp, end timestamp) - networkdays(stop timestamp, restart timestamp) (if stop & restart timestamps fall between start & end timestamp).
Is there a better way to write the above code than a big hairy if condition?