=IF(COUNT(E3:F3) = 2, MOD(F3-E3,1)-"8:00", "")
Hello,
The formula given above calculating the extra hrs after 8 hrs.
Is there any way to change it if there are entries below 8hrs the formula will give me the negative result?
Sample
14:00 => 01:00 = 3
14:00 => 21:00 = -1
Many Thanks