LibreOffice Calc SECOND function returning wrong value - why?
I have a table with a timestamp column (column A) that contains the timestamp with millisecond resolution.
Example:
I have separate columns for extracting different time 'components' (year, month, date, etc.), but the seconds column (SS) is giving the wrong value for the rows highlighted in red.
The formula for column SS is simply: =SECOND([timestamp_column]), for example in row 2, it is =SECOND(A2)
Why is it giving the wrong value for some rows?
It dawned on me upon looking closely that for all rows where the SECOND function returns the wrong answer, they are all the correct SECOND value +1. Looking at the milliseconds in the source column, I realized that they are all 500ms or more 'past the second'...therefore, the SECOND function must be ROUNDING.
The ONLY indication of this is nothing more than implied here: enter link description here
where is says:
That is the only use of the word "ROUND" on the entire page.
The formula to workaround this behaviour (which is not a bug, it is just obtuse) is:
=SECOND(INT(A2*86400)/86400)
which truncates the milliseconds off the source, or
=TEXT(SECOND(INT(A2*86400)/86400),"00")
if you want it formatted as a double digit.
The table now correctly extracts the 'CURRENT SECOND' of the timestamp in question, instead of the 'NEAREST SECOND':
- How to programmatically determine if the default parameter value was used?
- Unable to create a local function because "can't capture dynamic environment in a fn item"
- Use a bash function inside an 'at' job
- How to use eval() in a function from library with functions which are defined outside of this library?
- How can I execute PHP code from the command line?
- Returning a row of 2D array as comma delimited string given row number
- Creating Clock in React
- Is there way to add one more argument to the function(which has var args) with default value without breaking existing calls?
- how to make this function periodic in MATLAB?
- what is the difference between function declaration and signature?
- Best way to ensure user to specify one and only one of the two function parameters in Python
- Function that has parameters as pointers is not working when I take in addresses of variables
- How to achieve @args splatting in an advanced function in Powershell?
- How to add multiple values to a key in local storage
- Is it more efficient (or better in other ways) to modify an input parameter or declare a new variable and modify that?
- Difference in function parameter: double pointer VS 2D array
- How to access custom functions defined in functions.php from a single post template file
- Simplest/cleanest way to implement a singleton in JavaScript
- Default function arguments in Rust
- Is there a R function that detects a specific string and replaces it by the value of another observation based on a number within the string?
- I am trying to make a Fraction Calculator in HTML Javascript, I need to simplify the fraction how can I do this?
- Tracking Python code execution by printing accessed functions
- C++ function parameter overload with parent-child arguments
- What is the difference between call and apply?
- Where can I find AzureWebJobsStorage and AzureWebJobsDashboard connection string?
- How do I expand out an alphanumeric string in R?
- Why does the function name in .o file different from the one in .cc file after compiling?
- Javascript Function using a parameter defined in the future
- Can you store functions in an array in Objective-C?
- How to pass an array to a function in VBA?