calculate time in different timezone

[robertvdb]

I have a sheet where I display the current time using this VBA formula:

Sheet1.Cells(2, 2).Value = Format$(Now, "hh:mm:ss")

The cell is formatted Custom hh:mm:ss

Now, in another cell, I want to show the same time, but one hour later.

What would be the formula ?

Thanks

 

[myall_blues]

Sheet1.Cells(3, 2).Value = Format$(Now+1/24, "hh:mm:ss")

 

[sadath]

Sheet1.Cells(2, 2).Value = Format$(Now, "hh:mm:ss")
Sheet1.Cells(2, 3).Value = Format$(Now + TimeValue("01:00:00"), "hh:mm:ss")

 

[robertvdb]

Thanks myall and sadath ! Both work fine , however I prefer sadath's solution.