Userform Time crossing Midnight not working

Hi there,

I have broken this userform out of a larger program. It is essentially used to set the current time zone and then set a time using the spin buttons. The time on the top is local time and on the bottom is Z time which simply follows along with the local time by adding/subtracting the set time zone. The problem is it goes haywire when you cross midnight. If someone who has experience in adding/subtracting times in vba can have a look over it that would be great.

Thanks,
Marcus

Hi Norie,

Your right I am in the + side of the world so I haven't included the -.

By haywire I mean if the TZ is +10 and local time is say 14:00 as you use the spin button to move the hours down when the local time gets to 10:00 the Zulu time is 00:00 and then starts counting up so local goes to 09:00 and Zulu goes to 01:00 when is should be 23:00 the previous day.

Hope that explains it. If you just keep spinning down on the hour button you will see the change.

Cheers,
Marcus

Thanks Norrie and WBD I appreciate you taking the time to help.

WBD thanks heaps for rewriting the whole thing, works brilliantly and saves code over my clunky effort.

Cheers,
Marcus