Hi Wade, Assuming A1 has properly formatted time and not text, this should give you what you want:
=TIME(HOUR(A1)+1;MINUTE(A1);0) tc ________________________________ From: Wade Smart <[email protected]> To: [email protected] Sent: Wed, February 23, 2011 8:05:10 PM Subject: [users] Adding 1 hour 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 -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- ------------------------------------------------------------------------ To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] with Subject: help -- ------------------------------------------------------------------------ To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] with Subject: help
