Add 1 hour to data

israel · Aug 26, 2009

I have data 1 tru 200 with time "12:01:04". How can I add a hour to read
"1:01:04"
so when they move the clock in March '10 I will have the correct data.

Thank you

Max · Aug 26, 2009

Try in B1: =A1+"1:00:00"
Copy down

Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

Add 1 hour to data

israel

Max