Time with Time Zone?


S

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.
 
Ad

Advertisements

R

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

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
 
S

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.
 
Ad

Advertisements

R

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top