calculate time between 22 and 6

[FioreMatto]

Good morning
in Column A there is a time in column B the result to be obtained example A1 = 01:00 how many hours are between 22:00 and 6:00 result in B1 3:00

[WideBoyDixon]

How about:

=IF(AND($A2>$E$1,$A2<$D$1),0,MOD($A2-$D$1+1,1))

WBD

[FioreMatto]

Thanks for the help