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.