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