See Chip Pearson's site for working with Time Zones

http://www.cpearson.com/excel/TimeZo...lightTime.aspx

At least one of the Functions will serve your needs to replace the +3/24


Gord Dibben MS Excel MVP


On Sat, 7 Feb 2009 11:17:01 -0800, Joe Wildman
wrote:

Well, people from all around the world will be using this so that will not
work, so what i need is anyone from any time zone will default to PT time,

"John" wrote:

Hi Joe
I don't know your time zone, so added 3 hours, you can see in the formula
the 3 so change it to what you need.
This formula will do the same, just format "Custom and select date & time
=NOW()+3/24
Here is you formula with 3 hours added.
=MONTH(NOW()) & "/" & DAY(NOW()) & "/" & YEAR(NOW()) & " " &
HOUR(NOW()+3/24) & ":"& MINUTE(NOW())
HTH
John
"Joe Wildman" wrote in message
...
Hello, I put togeather this code below, can someone tell me how to get
this
to show up as Pacific time if you are using a PC not in that time zone?
Also
is there a way to make the cell update as the time changes?

=MONTH(NOW()) & "/" & DAY(NOW()) & "/" & YEAR(NOW()) & " " & HOUR(NOW()) &
":" & MINUTE(NOW())