Hey everyone...need some help...I have a form, that has the different
timezones on it, I need to create it so, that when I click on
commandbutton1, it will update the current time in each timezone. I've
tried everything I could think of, and it comes out wrong. I've tried
time - val("01:00:00"), time - val("1"), time - "01:00:00", i've tried
a few other things as well, but it is still not giving it
correctly...any help will greatly be appreciated...


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=439989

Sub AB()
Debug.Print Format(Time, "hh:mm:ss")
Debug.Print Format(Time + TimeSerial(1, 0, 0), "hh:mm:ss")
Debug.Print Format(Time - TimeSerial(1, 0, 0), "hh:mm:ss")
End Sub

produced:

14:13:08
15:13:08
13:13:08

--
Regards,
Tom Ogilvy

"dok112" wrote in
message ...

Hey everyone...need some help...I have a form, that has the different
timezones on it, I need to create it so, that when I click on
commandbutton1, it will update the current time in each timezone. I've
tried everything I could think of, and it comes out wrong. I've tried
time - val("01:00:00"), time - val("1"), time - "01:00:00", i've tried
a few other things as well, but it is still not giving it
correctly...any help will greatly be appreciated...


--
dok112
------------------------------------------------------------------------
dok112's Profile:
http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=439989