How to add/remove seconds to a datetime field?
I have an array with measurements whose time is elapsed seconds
column A contains the measurements, column B the seconds since the start
in C, I calculated the number of seconds between 2 measures starting from the beginning
A=mesure B=secs C=delta secs D=yyyy-mm-dd hh:mm:ss
43,9 175293 965
45,8 175474 181
58,9 175795 321
If I can convert column C to hh:mm:ss in time, e.g. 965/86400 = 1899-01-01 00:16:05
I don’t see how I will add these time values to my start time 2023-01-16 22:50
I would like in D something like 2023-01-16 22:50 + duration of column C in seconds.