Thanks Randy,your formula works perfectly fine on the report, I did test this. However, I'm trying to implement mine as calculated custom field and here it doesn't, do you have any idea why it might be the case? also what is workRequired and why do you use it instead of Planned hours?