Add hours to Time() in VBA

[insanity2]

This is driving me nuts or maybe it can't be done. I created a form with a labelbox called Clock that gives the current time as described in thread705-1282461. I want to create a clock with UTC time next to it.

How can I subtract 1 hour from the Time() function?

 

[RoyVidar]

Did you try DateAdd?

[tt]dt = Time
debug.print dt, dateadd("h", -1, dt)[/tt]

Roy-Vidar

 

[insanity2]

Didn't work. Still gives Run-time Error 424. Object required.

Could it be I can only use the "On Timer" event for just one caption on the form?

 

[insanity2]

Correction...I got the second clock to work. I named the label wrong, but your suggestion didn't subtract the hour off.

 

[insanity2]

AND it must be my goofy Vista machine, but this code worked finally:

ZuluClock.Caption = time + TimeSerial(-1, 0, 0)