Results 1 to 4 of 4

Running Clock in Excel with different Time Zone

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    3

    Smile 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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Running clock in excel 2010
    By Rhett21 in forum Excel General
    Replies: 1
    Last Post: 10-22-2012, 12:18 PM
  2. Excel Time zone problem
    By bittu2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2012, 11:37 PM
  3. Need to start Clock according to Zone wise
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-18-2010, 04:04 PM
  4. How to start a clock according to zone wise
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2010, 07:52 PM
  5. Replies: 1
    Last Post: 12-17-2005, 05:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1