Saturday, January 15, 2011

Adding time in Excel

Dear Readers,

Last week i came across a scenario where i have 4000+ rows which has time on it and i need to add 2 hrs to the each rows. I was wondering if i could do it thru some formula. With no time i got the solution.

The formula i used is  " = A1+ time(hr,min,sec)". 
(Eg: =03:00:00 AM + time(2,0,0) will give us 05:00:00 AM.) 

That's it now you can duplicate the formula to 4000 rows and you get your result. Make sure you copy the formulated column and paste with special values in different column so that it can be used for further reference else you can't refer this column for other manipulations.

No comments:

Post a Comment