I’m trying to calculate time and develop a couple of Yes or No statements.
I am able to calculate the difference between two times, which can be positive or negative. If the difference is <=60 I need a Yes statement in a cell, If the difference is >=61 then I need a No statement in a cell. Now comes the first tricky part - I also need a No statement if the time is <=0.
Yes = 1 minutes to 60 minutes
No = 61 or greater
No = -1 minutes or less (7:20 – 7:10 = -10 minutes)
Here is the second tricky part, while there is nothing in the cells (null), I need something other than a Yes, or No in the cell. This will enable me to calculate my denominator later –which will be the total number of Yes and Nos.
Here is the cell I’m currently using =IF(K33*1440>0,IF(K33*1440<60,"Y","N"), "N") time format is “custom [mm];-[mm].” This came from another member of this forum (uandras) and works great except for the second trick part. It puts No in every empty cell.
Eventually I want to calculate the rate of Yes as follows: Num Yes / (nub Yes + nub No)= X%
I've attached an example of what I'm working with.
Any help is appreciated.
Thanks - Wattage