Time with Time Zone?

[scottnshelly]

Is it possible to set a format to show the time with the time zone?

I've got a workbook that logs times, the only problem is, it is shared
with users across Eastern, Central and Mountain time zones. Can I
change the format to read 14:25:46 EST or 18:12:34 MDT?

Thanks.

 

[raypayette]

You would have to identify the Time Zone somewhere for each user; let's
say in cell A1 you would have EST for one user and PST for another.
Then all you have to do is to subtract 3 hours by using this formula:
=HOUR(NOW())-IF(A1="PST",3,0)-IF(A1="MST",2,0)-IF(A1="CST",1,0) & ":"
& MINUTE(NOW())

 

[Ron Rosenfeld]

Is it possible to set a format to show the time with the time zone?

I've got a workbook that logs times, the only problem is, it is shared
with users across Eastern, Central and Mountain time zones. Can I
change the format to read 14:25:46 EST or 18:12:34 MDT?

Thanks.

How will you know which time zone to apply?

Once you know that, you can use a custom format:

h:mm AM/PM" EDT"


--ron

 

[scottnshelly]

The problem is, I don't always know which time zone a user is in. Are
there any solutions that don't require previous knowledge of the user's
time zone?

I'm currently using:
ActiveCell.Value = Format(Date, "mm/dd/yyyy")
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = Format(Time, "HH:mm:ss")


Thanks.

 

[raypayette]

You might be interested in a software that can locate a user from hi
IP:
http://www.ip2location.com

 

[Ron Rosenfeld]

The problem is, I don't always know which time zone a user is in. Are
there any solutions that don't require previous knowledge of the user's
time zone?

I'm currently using:
ActiveCell.Value = Format(Date, "mm/dd/yyyy")
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = Format(Time, "HH:mm:ss")


Thanks.

If you cannot determine the user's time zone, I don't see how you can format a
cell referencing referencing his time zone.
--ron