Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Now()
I would like to know if I how best to convert the value created using Now()
which displays the current time for various time zones. How would I increment the time by 1 hour to convert a CST to an EST? Thanks, Brad |
#2
|
|||
|
|||
if your date is in A1...
=+A1+(1/24)) 1 hour / 24 hours HTH, -- Gary Brown "Brad" wrote: I would like to know if I how best to convert the value created using Now() which displays the current time for various time zones. How would I increment the time by 1 hour to convert a CST to an EST? Thanks, Brad |
#3
|
|||
|
|||
Gary, that fixes it... thanks! Brad
"Gary Brown" wrote in message ... if your date is in A1... =+A1+(1/24)) 1 hour / 24 hours HTH, -- Gary Brown "Brad" wrote: I would like to know if I how best to convert the value created using Now() which displays the current time for various time zones. How would I increment the time by 1 hour to convert a CST to an EST? Thanks, Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|