#### asyamonique

##### Well-known Member

- Joined
- Jan 29, 2008

- Messages
- 1,107

Code:

`=IF(COUNT(E3:F3) = 2, MOD(F3-E3,1)-"8:00", "")`

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