Subtract hours

[Ltat42a]

Hello All,
I have a formula that adds hours based on my time zone (=H3+TIME(9,30,0)). H3 equals 00:00, the result is 09:30.
It works pretty good, but, I was trying to find one that will subtract hours. If I were to put 00:00 in H3 and subtract 4 hours, the result should be 20:00.

Any ideas?

Thanx.

[zbor]

Try:

=MOD(H3-"9:30:00",1)

[Pepe Le Mokko]

Try =mod(h3-"04:00",1)

[Ltat42a]

Try =mod(h3-"04:00",1)

This works great, Thank you!