Thread: Now()
View Single Post
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

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