Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting like a clock (2000)

    Hi,
    Hopefully this is a really simple question.
    I have a cell that calculates the difference in hours, minutes & seconds between a start time and now(). Is there a way that I can physically get this to count onscreen?
    If so, how?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Counting like a clock (2000)

    A very simple solution: say that you put the time difference in cell A1.

    Create and run the following macro:

    Sub Test()
    Range("A1").Calculate
    Application.OnTime Now + TimeValue("0:00:05"), "Test"
    End Sub

    This will update the time every 5 seconds (0:00:05)

    If you search this forum for stopwatch, you should find some more sophisticated ideas.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Counting like a clock (2000)

    Does the macro in <post#=44233>post 44233</post#> help you at all?

    Steve

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting like a clock (2000)

    Thanks Hans, works a treat!

Posting Permissions

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