I have the following sheet:

  | A               | B          | C
1 | 23/2/2020 12:00 | 5          | 2:00
2 | 12/4/2020 13:00 | 2          | 2:0

And I want to calculate how many days after and how many hours after the date will be. So as an example the 23/2/2020 12:00will be 28/02/2020 14:00.

Just by doing =A1+C1 I get 23/2/2020 12:00 (I add the hours) but how I will increase the datetime by days?

1 Answer 1


=A1+B1+C1 In your example. If the column values are formatted as the picture below shows.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.