Time with Time Zone?

  • Thread starter Thread starter scottnshelly
  • Start date Start date
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.
 
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())
 
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.
Click to expand...

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.
 
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.
Click to expand...

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
 
Back
Top