On 24/02/2011 01:05, Wade Smart wrote:
I have a column with times in it: 09:00 - 10:00, and I would like to
add one hour to it, or subtract from it. Basically its a time zone
issue. Ive gone through the functions, some forums but Im not sure
this can be done in spread sheets.
Wade
Assuming the data are in column A starting in row 1, then in B1 enter
the formula "=A1+1/24" (without the quotes). Drag this down column B as
far as necessary. What you are doing is adding 1/24th of a day i.e. 1 hour.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
