add 1 hour to timestamp in excel

Question

Ive got an excel sheet with a list of timestamps, they have come in with the wrong hour on them - they have ended up being an hour behind, how can update them ?

Each cell is formatted as 2013-05-24 17:05:04 and i want to update it to 2013-05-24 18:05:04, ive tried splitting the time and date, adding one to the time and then CONCATINATE the two cells back together but it seems like a rather long way, is there something simpler ?

Answer 1

Add 1/24 to the date.

1 day in excel is 1 unit, so 1 hour would be 1/24.