Excel add one hour

Question

I have in cel A1 with the following contents:

7:30:43 which is a time.

But now i want to use a formula to add one hour. What is the best way or how can i do this?

As a financial developer who produces solutions mixing VBA, .NET VSTO and Excel worksheet functions, this is most certainly not off topic. — Ian, Oct 05 '15 at 14:54

score 118 · Accepted Answer · edited Sep 21 '11 at 21:20

118

=A1+TIME(1,0,0)

Although, maybe this should be posted on Super User.

edited Sep 21 '11 at 21:20

apaderno

28,547
16
75
90

answered Sep 21 '11 at 21:08

leonigmig

2,736
3
25
21

14

You can always just use =A1 + 1/24 – RonnieDickson Sep 21 '11 at 21:25
Similiar Posting on Super User @http://superuser.com/questions/194302/how-to-add-80000-hours-to-all-the-datetime-values-in-a-column-in-ms-excel-shee – Ben_Coding Jul 24 '15 at 14:18

score 14 · Answer 2 · edited Mar 18 '14 at 15:37

14

In cell A1, enter the time.
In cell B2, enter =A1+1/24

edited Mar 18 '14 at 15:37

Anonymous

11,748
6
35
57

answered Mar 18 '14 at 15:16

jenny

141
1
2

score 0 · Answer 3 · edited Nov 13 '19 at 14:29

0

This may help you as well. This is a conditional statement that will fill the cell with a default date if it is empty but will subtract one hour if it is a valid date/time and put it into the cell.

=IF((Sheet1!C4)="",DATE(1999,1,1),Sheet1!C4-TIME(1,0,0))

You can also substitute TIME with DATE to add or subtract a date or time.

edited Nov 13 '19 at 14:29

Pᴇʜ

56,719
10
49
73

answered Sep 21 '11 at 23:49

Wuggles

11
4

Excel add one hour

3 Answers3