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.


--
scottnshelly
------------------------------------------------------------------------
scottnshelly's Profile: http://www.excelforum.com/member.php...fo&userid=7301
View this thread: http://www.excelforum.com/showthread...hreadid=565881

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())


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=565881

On Thu, 27 Jul 2006 23:26:52 -0400, scottnshelly
wrote:


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

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.


--
scottnshelly
------------------------------------------------------------------------
scottnshelly's Profile: http://www.excelforum.com/member.php...fo&userid=7301
View this thread: http://www.excelforum.com/showthread...hreadid=565881

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


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=565881

On Mon, 31 Jul 2006 22:15:32 -0400, scottnshelly
wrote:


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