Formula calculates working hrs.

[asyamonique]

=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

 

[onlyadrafter]

Hello,

after quite a bit of changing, but formula not very elegant

=IF(COUNT(E3:F3)=2,IF(MOD(F3-E3,1)-"8:00"<0,TEXT((((F3-E3)*24)-8),"#"),MOD(F3-E3,1)-"8:00"),"")

 

[asyamonique]

Hello,
Thanks for the reply but I've got below result

[TABLE="width: 327"]
<tbody>[TR]
[TD="class: xl67, width: 109"]8:00 PM[/TD]
[TD="class: xl67, width: 109"]3:00 AM[/TD]
[TD="class: xl64, width: 109"]-25[/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Maybe

=IF(COUNT(E3:F3)=2,24*MOD(F3-E3,1)-8,"")

 

[asyamonique]

Thanks but still I couldn't get correct result.