Results 1 to 1 of 1

UTC (zulu) time display

Threaded View

astar24 UTC (zulu) time display 05-20-2009, 12:12 PM
  1. #1
    Registered User
    Join Date
    04-06-2009
    Location
    USA
    MS-Off Ver
    2007
    Posts
    35

    UTC (zulu) time display

    Hello folks,
    I would like to display a clock in one of the cell of my worksheet, and I would like it to be update pretty often. I don't really need anything other the 4 numbers (hh:mm) displayed in the cell as plain text, but i would like it to be updated every minute. I used the function NOW() but I have 2 problems:
    -first: it doesn't recalculate if not every 4-5 minutes right now (this may be an easy question for you guys)
    -second: I need the time to be UTC (military zulu time), and I can't go by adding the hours to the now function, because the worksheet needs to be used in different timezones, and needs to be independent. users cannot modify it.
    maybe the best solution would be to link the cell to a web data source.. and have it update every minute. if you have any suggestion, please let me know
    thanks in advance!
    andrea
    Last edited by astar24; 05-20-2009 at 05:13 PM.

Thread Information

Users Browsing this Thread

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

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