0 Replies Latest reply: Jul 26, 2010 4:50 PM by Dinesh Thoniparambil RSS

    Convoluted Cycle Time Report

      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?

      Thanks,

      Dinesh.