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!