In Date/Time terms, 1 = 1 day. Therefo1 hour = 1/24.

So, time in a zone x time zones "ahead":
= Now() + (x / 24)

or, using VBA in code:
= DateAdd("h", x, Now())

or, using Excel formulas in a cell:
= Time(Hour(Now()) + x, Minute(Now()), Second(Now()))

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"david" wrote in message
...
need to create a spreadsheet with greenwich mean and Tokyo time