| 
            
            
            
            
              Soustraction/différence calc
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            281
           | 
          
            July 3, 2025
           | 
        
        
          | 
            
            
            
            
              How to change Time Zone of a long column of time entries
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            5348
           | 
          
            April 15, 2025
           | 
        
        
          | 
            
            
            
            
              How do I convert a UNIX timestamp to libreoffice date time?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            10
           | 
          
            14673
           | 
          
            January 7, 2025
           | 
        
        
          | 
            
            
              
            
            
              Calc erroneously "rounds" the minutes in this case. (¿?)
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            34
           | 
          
            3604
           | 
          
            October 24, 2024
           | 
        
        
          | 
            
            
            
            
              How do I format the number in a cell as a duration?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            1117
           | 
          
            September 20, 2024
           | 
        
        
          | 
            
            
            
            
              How do I change the default date/time format?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            12
           | 
          
            12024
           | 
          
            September 25, 2023
           | 
        
        
          | 
            
            
            
            
              How to add/remove a duration in seconds to a datetime field, ex: 2023-01-16 22:50 + 865secs?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            3362
           | 
          
            January 18, 2023
           | 
        
        
          | 
            
            
              
            
            
              Calc XY-scatter-diagram: how to "fold" timed-data and overlay with previous year?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            1984
           | 
          
            November 29, 2022
           | 
        
        
          | 
            
            
            
            
              How to create a chart with date-time values.
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            16
           | 
          
            28893
           | 
          
            September 9, 2022
           | 
        
        
          | 
            
            
              
            
            
              Adding to a time field
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            12
           | 
          
            5288
           | 
          
            March 25, 2022
           | 
        
        
          | 
            
            
            
            
              Como fazer uma data passando 3 células como os argumentos da fórmula =DATE()?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            1230
           | 
          
            February 14, 2022
           | 
        
        
          | 
            
            
            
            
              LO 7.2 Calc, date time functions - Difference between FR & English version - how to get the decimal difference of two dates?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            1222
           | 
          
            January 2, 2022
           | 
        
        
          | 
            
            
            
            
              Is there a way to type something in the format "MM:SS" without it turning into "HH:MM:SS AM/PM"?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            934
           | 
          
            March 10, 2021
           | 
        
        
          | 
            
            
            
            
              Arithmetics with dates and times?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            13
           | 
          
            4506
           | 
          
            February 23, 2021
           | 
        
        
          | 
            
            
            
            
              Combining "NOW" functions
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            1352
           | 
          
            January 24, 2021
           | 
        
        
          | 
            
            
            
            
              How to round date differences to specific times?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            1452
           | 
          
            November 25, 2020
           | 
        
        
          | 
            
            
            
            
              Cell does not automatically update over days
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            5
           | 
          
            2040
           | 
          
            July 27, 2020
           | 
        
        
          | 
            
            
            
            
              How to autorefresh Calc sheet
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            1163
           | 
          
            July 17, 2020
           | 
        
        
          | 
            
            
            
            
              Timezone of creation date for docx file
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            1630
           | 
          
            July 6, 2020
           | 
        
        
          | 
            
            
            
            
              How to show more than 24 hours in Time format cells
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            14
           | 
          
            7985
           | 
          
            July 31, 2021
           | 
        
        
          | 
            
            
            
            
              How to calculate time difference in years, months and days?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            8
           | 
          
            6382
           | 
          
            May 11, 2020
           | 
        
        
          | 
            
            
            
            
              How to sum over a range that automatically restarts when a condition is met?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            4
           | 
          
            1061
           | 
          
            July 31, 2021
           | 
        
        
          | 
            
            
            
            
              Imported date not converting the time right.
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            941
           | 
          
            February 23, 2020
           | 
        
        
          | 
            
            
            
            
              Calc how to add time increments?
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            7
           | 
          
            37970
           | 
          
            July 31, 2021
           | 
        
        
          | 
            
            
            
            
              Is there an equivalent to en_DK or root.UTF-8 locale for LibreOffice?
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            3
           | 
          
            1541
           | 
          
            April 29, 2019
           | 
        
        
          | 
            
            
            
            
              in calc, format time
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
           | 
          
            2
           | 
          
            778
           | 
          
            February 12, 2019
           | 
        
        
          | 
            
            
            
            
              weird Calc results from elapsed-time formula, specific times only
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            7
           | 
          
            2193
           | 
          
            January 1, 2019
           | 
        
        
          | 
            
            
            
            
              timestamp calculations
            
            
           | 
          
              
                 
              
              
                 
              
              
                 
              
              
                 
              
           | 
          
            11
           | 
          
            6992
           | 
          
            July 31, 2021
           | 
        
        
          | 
            
            
            
            
              [Calc] Calculating time elapsed problem
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            6
           | 
          
            10534
           | 
          
            July 31, 2021
           | 
        
        
          | 
            
            
            
            
              How can make live time tracking in a cell
            
            
           | 
          
              
                 
              
              
                 
              
           | 
          
            1
           | 
          
            683
           | 
          
            July 31, 2021
           |