Add seconds, minutes and / or hours in datetime field

2

I have a field with date and time in Excel (column F) and would like to add seconds, minutes and / or hours, but the form used, as in the example image below, adds the value in days (column G):

How do I add specific seconds, minutes, and / or hours?

    
asked by anonymous 27.11.2018 / 11:25

1 answer

4

I think what you're looking for would be this

=F2 + VALOR.TEMPO("02:00:00")

If your Excel is in English you will only have to see the equivalent method.

    
27.11.2018 / 11:31