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

need to create a spreadsheet with greenwich mean and Tokyo time

=A1+B1/24

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

--

HTH

RP

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

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