Need help with "IF" formula

[Roma1r]

Good day
I need different results when subtracting start / end times - see attached worksheet
I managed to get the results in column H19 if the shift name is "Non_Shift" but in column H18, when shift name is different to "Non_Shift" I need the result to be 10.5 hours, pls can you assist?
"

[Keebellah]

First, you file has links to files unavaliable to us since it's your path O:....
And please explain a little more about that 'Non_Shift",is that a default value for the Non_Shift line?

[Ace_XL]

Try in H18

=IF(C18="","",IF(C18="Non_Shift",(G18-F18)*24,IF(F18>G18,(G18-F18+1)*24,(G18-F18)*24)))


Is there a half an hour deduction that needs to be built in? If so, use

=IF(C18="","",IF(C18="Non_Shift",(G18-F18)*24-0.5,IF(F18>G18,(G18-F18+1)*24,(G18-F18)*24)-0.5))