Add seconds per hour - Excel

4

I have a column with the following values:

945
224
554
487

This would be the seconds that I need to add to another column with hour, minutes, and seconds

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

I'm doing it as follows

I get a value in second and add 00:00: on the front, example: 00: 00: 945 and excel returns me 0.0109375 What account does it do here? ) so I get that value and convert it to hour and the result is 00:03:57 , until then without problems, I just add with the column that contains the time.

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

    
asked by anonymous 29.06.2017 / 14:52

2 answers

6

You can do this as follows:

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

Segundos / 86400

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

Belowisanexampleofhowitwouldlook:

    
29.06.2017 / 15:07
3

Just divide the number of seconds you want to add by the total 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 up at the time.

    
29.06.2017 / 15:27