I am trying to figure out how I can subtract 2 times: day 1=7:20 am and day
2 = 14:45 answer should be 31:25. I need to use the result when averaging
the column. Formula used is : =IF(COUNT(N50,S50)=2,MOD(S50-N50,1),"")
giving me 7:35 which would be correct if within 24 hrs. TIA