Running Clock in Excel with different Time Zone

Need running clock in Excel... in A1 I have put running clock which is taking current system time. However, I want to add running clocks for EST in B1 - CST in C1 and PST in D1. Any help much appreciated.

Atatching excel... if anyone can update in same and attach back, will be very thankful.

VB code I used to display current system running clock

Global clockOn As Boolean
Sub runClock()
Range("A1").Value = Now()
If clockOn = True Then
Application.OnTime Now + TimeValue("00:00:01"), "runClock"
End If
End Sub
Sub startClock()
clockOn = True
runClock
End Sub
Sub stopClock()
clockOn = False

End Sub

Hi - here is a link to describe how to get the timezone, from there you can offset as neccessary to the different zones:
http://www.cpearson.com/excel/TimeZo...lightTime.aspx

Gone through that link but litlle confused. Not that much familier with the codes

http://www.mrexcel.com/forum/excel-q...time-zone.html

Is that link any more help? Looking at post #5 put the code at the bottom in a module and then use:

Please Login or Register  to view this content.

Please Login or Register  to view this content.