Hi all,
I'm struggling to work out how to show how many hours difference there is between 2 timezones, especially when they are on different days.
I'm in the UK so Sydney is 11 hours ahead of me (which is tomorrow) but excel only seems to want to count backwards for this time.
Does anyone know how i can fix this?

Cell D26 is set as =NOW() formatted hh:mm:ss
Cell D29 pulls another timezone from a formula also formatted hh:mm:ss

I would like D33 to show the difference in time such as +5:00 or -5:00.

Thanks in advance