How can I add a numeric value to a TIME cell?

[Guest]

need to create a spreadsheet with greenwich mean and Tokyo time

 

[Bob Phillips]

=A1+B1/24

where A1 holds London time, and B1 is the hours difference

 

[George Nicholson]

In Date/Time terms, 1 = 1 day. Therefore:1 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,