Results 1 to 5 of 5

Thread: Clock display

  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Clock display

    Hello all,

    Is there a formula that will excute an up to the minute running clock that displays the hh:mm in a cell, while the file is open?

    Thanks,
    Albert

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    No. You would have to use code with timers and it would bog down your spreadsheet.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. The Following User Says Thank You to rory For This Useful Post:

    abaas (2011-12-01)

  4. #3
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts
    You could stick a web query to a clock website in your workbook to show the up-to-the-minute time, and set the connection properties to refresh every 1 minute. But, obviously, that's overkill ... but it would work.

    One such website:
    http://www.worldtimeserver.com/current_time_in_GB.aspx

    ( right-click over the time and choose Export to Excel ... in Excel change Data Connection property to set refresh rate )

  5. The Following User Says Thank You to GlennB For This Useful Post:

    abaas (2011-12-06)

  6. #4
    Super Moderator BATcher's Avatar
    Join Date
    Feb 2008
    Location
    A cultural area in SW England
    Posts
    3,414
    Thanks
    33
    Thanked 195 Times in 175 Posts
    I may be missing the point, but isn't there an up-to-the-minute clock at the bottom right-hand side of your screen?
    BATcher

    Time prevents everything happening all at once...

  7. #5
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Yeah, that's what I look at too. But the request was to have a time embedded in a cell ... ( shrug ).

Posting Permissions

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