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?
Hi, I’ve read this threa dwith interest as I have a similar but not idential requirement. I have an Estimated Time (numbers) column (in minutes… changable), and a time tracking column showing Actual Time worked on each task. I simply want a third column to calculate the difference between Estimated and Actual and display it as a %. I this possible? Thanks for any guidance you can offer.