+ Reply to Thread
Results 1 to 3 of 3

Running Clock to show PC time, but starts from 00:00:00

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    42

    Running Clock to show PC time, but starts from 00:00:00

    Hello again wizards!

    Sorry, third request in about 48hrs from me. Hopefully this is a quick one.

    I've got a bit of code to show a running clock, called by Worksheet_Open. This works, but the clock always starts from 00:00:00, where I would like it to display the time as used by the PC. Oddly enough, if you go into VBA and manually reset the project, when you go back to the Excel worksheet, it does actually display laptop time correctly!

    Would appreciate it if one of you lot could cast your eye over it.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Running Clock to show PC time, but starts from 00:00:00

    Good afternoon creationracing

    You are SO going to kick yourself …

    Consider this line :
    Please Login or Register  to view this content.
    This is asking cell H1 to show the current time less t - which is set as start time in the StartRT module. This module is, in effect, a timer module, not a clock module.
    To show current time, change that line to :
    Please Login or Register  to view this content.
    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    01-29-2007
    Posts
    42

    Re: Running Clock to show PC time, but starts from 00:00:00

    You're right. I am going to kick myself. Severely, and repeatedly.

    I copy>pasted the code from a lap timer, and completely missed the bit where I change it back to a clock!

    Oh well, an easy fix is good! Thanks for the sanity check!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show Continuous Time Running on Form.
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2018, 09:40 AM
  2. [SOLVED] Running 2 If/Then Conditions for Time Clock
    By keross in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-28-2018, 04:46 AM
  3. Replies: 5
    Last Post: 07-17-2017, 12:44 PM
  4. Replies: 2
    Last Post: 08-28-2015, 07:14 AM
  5. Time Study - Continuous running clock mixed with stops
    By jorjacman in forum Excel General
    Replies: 0
    Last Post: 01-10-2014, 09:55 AM
  6. Running Clock in Excel with different Time Zone
    By kz.umair in forum Excel General
    Replies: 3
    Last Post: 11-28-2013, 06:21 AM
  7. 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