CODEWITHSUNDEEP
excelexcel-formula
sam
sam

Reputation: 10074

add 1 hour to timestamp in excel

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 ?

Upvotes: 3

Views: 30088

Answers (2)

Abe Gold
Abe Gold

Reputation: 2347

If the time is in A1 then B1 should be =A1+TIME(1,0,0), then you can copy and paste values

Upvotes: 10

Jerry
Jerry

Reputation: 71538

Add 1/24 to the date.

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

Upvotes: 12

Related Questions