![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Posts: 16
|
I am wondering if I can set the timer in VB to Greenich time instead of the computer's time?
|
|
|
|
|
|
#2 | |
|
Board Regular
Join Date: Mar 2002
Location: Cincinnati, Ohio, USA
Posts: 6,824
|
Hi Murrati.
Can you simply subract the difference? For example, create a Constant? I'm not sure which timer function you are referring to. The VB function which counts seconds from midnight? 0 to 86,399? Maybe this example will help you... Sub Test calls for a five second delay by passing the value 5 to LenTime in sub SD The function UTC_Timer takes the value of the current Computer timer and re-arranges it according to your constant, TimeDifference. I am 4 hours behind GMT. Therefore TimeDifference will = 14400. Or 60 Seconds * 60 Minutes * 4 Hours Change to suit... I hope this helps you, Tom Quote:
[ This Message was edited by: TsTom on 2002-04-23 21:56 ] |
|
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|