To calculate the number of seconds between two dates, I am using the TIMESTAMPDIFF function (only if there is a start datetime).
IF(ISBLANK(#Start), 0, TIMESTAMPDIFF("SECOND", #Start, #End))
For some reason it is not reporting the correct number of seconds. I have highlighted the easiest example in that the difference is clearly 41 seconds. But the function I am using returns 40 seconds. Some, not all, are similar.... the first row should be 141 seconds. The seconds row of 233 is fine.
Is there anything that can be done to fix this, or is this a known issue with the TIMESTAMPDIFF function and what would the alternative be?
Many thanks in advance.
Please sign in to leave a comment.