Results 1 to 5 of 5

Thread: Displayin Date/Time in "original" time zone

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-15-2012, 07:24 AM #1
    Rasm
    Rasm is offline
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    14

    Displayin Date/Time in "original" time zone

    I have date/times that were recorded in another time zone - So I want to be able to read what time zone the data were recorded in - next I want to display the date/time in the "original" date/time or local time. In other words - the data was recorded in Germany and I open the sheet in New York - I want the date/time to be shown in German time and/or New York time - is there a property I can set to control how the date/time is displayed.

    I want to do this via VBA code
    Last edited by Rasm; 04-15-2012 at 07:26 AM.
    xl2007 - Windows 7
    xl hates the 255 number
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Versions of my "Get Field" and "Get Reverse Field" formulas
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 06-02-2017, 06:15 PM
  2. Reversing a "First Middle Last" Name to "Last, First Middle" Name Format
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 5
    Last Post: 01-06-2014, 10:04 PM
  3. Set "Access content programmatically" checkbox with vba
    By kudude in forum Excel Help
    Replies: 5
    Last Post: 04-18-2013, 02:30 AM
  4. Follow-up to "Excel Number Format: Indian Style Comma Separation"
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 2
    Last Post: 04-14-2012, 10:46 PM
  5. Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 0
    Last Post: 03-20-2012, 03:46 AM

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
  •  

Forum Rules