Hello Everyone!
I'm new to the forum and I'm requesting assistance with a formula. I run a report for my company that measures progress (typed manually) per work station. I'm currently trying to calculate production times per area using a start date, the today() function and the inputed progress percentages.
Is there a formula that will help me calculate the time spent per station and stop calculating days when the process is completed?
I have used a conditional formula but doesn't seem to work:
=IF(F8="","",IF(F8<100%,$O$5-$S$3,IF(F8=100%,$S$3-$O$5)))
I have attached a sample spreadsheet to illustrate. I'm grateful for any help that you can provide.
Best to all!