Displayin Date/Time in "original" time zone

[Rasm]

Rick
I get data from all over - the records(rows) are date/time stamped from a process (production) - so when I report back my findings - I want to lock in the date/time stamp to what ever time zone the data was collected in. So regardless of what part of the world the sheet is viewed - the date/time stamp is locked and displayed as it was at the site where the data was originally collected. I hope this makes sense. Currently I add a ' in front of the date/time and then format it as a text field - But that way I have to use a format of YYYYMMDD hh:mm:ss - otherwise I cannot sort the date by time.
I hope this makes it clear what I am trying to do. So In a perfect worl I want the date/time to be displayed in using the time zone where it was collected - but formatted to the PC that is opening the sheet. I.e. the Europeans use military time and not AM/PM

[Rick Rothstein]

Sorry about the delay getting back to you... I lost track of this thread.

There is information about getting timezone information here...

Untitled Page

I am guessing you would want to put this in a cell next to the time when the time is entered? If so, then you would want to do that using event code.

[Rasm]

Thanks Rick - yeah I was afraid I had to do a lot coding - but that is very good info - much appreciated