Sum seconds, minutes and/or hours in field date time

Asked

Viewed 113 times

2

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

planilha

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

excel
  • 1

    Downvoter, could you explain what you did not understand in the question? Or if you did, give the answer, or the reason for your "fair vote" and intelligent!

  • you don’t want the difference, right!? in case the expected return would be 15:54:47??

  • @Not... I want to add like, 2 minutes, so I’d stay: 2018-11-01 07:52:10

  • 1

    Turn the date to number, you will see that it returns in days. For example 2018-11-01 07:52:10 in numbers returns: 43405,3278935185. That’s 43405 days from the day 00/01/1900. Then you get the rest: 0,3278935185 and multiplies by 24 and gets the hours. And so on... With minutes and seconds. Or uses a ready function of Excel, which is easier.

1 answer

4


I think what you’re looking for is this

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

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

  • 1

    Perfect Matheus! That’s right. I can’t accept the answer yet, but it’s solved! Thank you.

  • You are welcome... I have hit my head a lot because of this too. Now there is a time to accept an answer?

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.