Now()

Brad · May 16, 2005

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

Gary Brown · May 16, 2005

if your date is in A1...
=+A1+(1/24))

1 hour / 24 hours

HTH,

Brad · May 16, 2005

Gary, that fixes it... thanks! Brad

Gary Brown said:
if your date is in A1...
=+A1+(1/24))

1 hour / 24 hours

HTH,