Now I’m looking for a time status field (4th column) which tells if the task is done on time or not.
If the value is positive it means task is done on time, if the value is negative it means the task is not done on time or delayed & if it is 0 it means nothing, the status should be blank then.
Please help me out in creating a formula for the 4th column where we could generate a time status result through the diff in time field. Or there is any other way of doing this other than a formula.
@GiannisKoukounas
Hey thanks for resolving and the formula works well.
But I’m stuck with one more issue at the moment. It is showing “on time” for tasks that are not yet started or not even allotted the Estimated hours, is it possible to keep it blank if there time spent field is empty?