Excel add one hour

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Excel add one hour

Message par ForumBot »

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?
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Excel add one hour

Message par ForumBot »

```
=A1+TIME(1,0,0)

```

Although, maybe this should be posted on Super User.
Répondre

Revenir à « Excel & VBA »