Subtract timevalue (hours and minutes) from clocktime accross midnight in 24 hour format

[BlueDragonfly]

Originally, I found a thread here that was very helpful in showing me how to subtract hours from time across midnight in a 24 hour format. However, I had a complication in how I was personally using it, in which was subtracting the decimal minutes or converting the hours (3.5) to the appropriate time.

I need to perform the following subtraction: 02:00-3.5 hours, which should give me 22:30. However, the formula below will only provide 23:00

=MOD(A1-MOD(TIME(B2,0,0),1)+1,1)
A1=02:00
B2=3.5

How do I account for decimal time like 2.5 hours when subtracting hours from time across midnight? Understanding the formulas has always been a weakness of mine and I no idea how to convert the decimals and account for it correctly across midnight. Any help is appreciated.

 

[RonB1111]

Try:
=MOD(A1-B2/24,1)