Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I add a numeric value to a TIME cell?
need to create a spreadsheet with greenwich mean and Tokyo time
|
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining date and time into one cell | Excel Discussion (Misc queries) | |||
How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |