4
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.
Just one explanation: Excel, and many other software, treat the date as the Julian day (the number of days elapsed from a given date) and the instant of the day as the fractional part. Thus an integer represents a date and a timestamp is represented by a real number where the date is an integer part and the instant of the day the fractional part. This type of representation presents numerous advantages in operations involving dates and for display just choose the format most suitable to the local standard where it is being used.
– anonimo