Add seconds to time - Excel

Question

I have a column with the following values:

945
224
554
487

That would be the seconds I need to add to another column with time, minutes and seconds

12:09:37
23:54:45
10:40:44
11:20:10

I’m doing it this way

I take a second value and add 00:00: at the front, example: 00:00:945 and excel returns me 0,0109375 (What account is he making here?) then I take this value and convert it to time and the result is 00:03:57, up there no problem, I just add with the column that contains the hour.

The problem is that it doesn’t work for more than 9999 minutes, it just doesn’t convert 00:00:11000 and and do not know what account Excel does to convert "manually"? Or do another way? Another point is that I have to manually type the 00:00: if I use a Concatenate this is as text.

Answer 1

You can do it this way:

1) Convert seconds to an Excel time value (yes, that’s the term):

Segundos / 86400

2) Then, in formatting convert it to a time field.

Below is an example of how it would look:

Answer 2

All you have to do is divide the number of seconds you want to add by the total number of seconds that corresponds to a day, which is 86400 seconds (24 hours * 60 minutes * 60 seconds). You’ll get a fraction, so just add to the hour.