8hrs

  1. A

    Formula calculates working hrs.

    =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

Some videos you may like

This Week's Hot Topics

Top