Forum Discussion
Getting a new Timestamp
Hi, Anonymous
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Here is a sample. Again, first column is type date/time, second is decimal number. I would need to generate a third column containing another timestamp where the value is the first one minus the second one. E.g. for the first line in this table, the result would be 6/17/2022 1:42:51 (which is 1:49 minus 6 minutes 9 seconds).
Thanks again.
Replying to myself: I converted the second column to type duration, and put it in a new column. The results seem to be correct for amount of seconds (i.e. 6.16405 is returned as 369.843). I then extracted the time of the first column, and substracted the duration. The results I got were wildly inaccurate; some instances somehow interpreted substracting around 240 seconds to extracting almost a full hour, while others showed extracting 129 seconds gave as result something around 4 hours before the original time. I'm not sure I understand why.