Forum Discussion
Calculating Time
Hi, So I have got 2 tables. For instance, table x and table y. Table x is basically a snapshot or the same table as table y, however table x is a snapshot taken at the start of a day at 05.30am ...
I can't provide a sample data since this is really confidential.
However, it's like.
Planned_Duration = 4.5 in table y
Initial_Duration = 3.5 in table x
Expected outcome should be = Planned_Duration in table y - Initial_Duration in table x
So it would be {Variance = 1.0}
Sorry, if you cannot find time to create meaningful sample data then I cannot find time to assist you.