Re: [libreoffice-users] lack of time resolution

On 9 Oct 2025 at 17:52, Patrick Dupre wrote:

From:                   Patrick Dupre <pdupre@gmx.com>
To:                     ooffice <users@global.libreoffice.org>
Subject:                [libreoffice-users] lack of time resolution
Date sent:              Thu, 9 Oct 2025 17:52:33 +0200

> Hello,
>
>
> I have an ascii file with
> Date Time     MeaValue
> 10/4/25 11:27:04 PM   43.9
> 10/4/25 11:27:05 PM   34.7
> 10/4/25 11:27:06 PM   45.4
> 10/4/25 11:27:07 PM   34.7
> 10/4/25 11:27:08 PM   34.2
>
> that I open with calc
> The 1st window is OK
> correctly showing the 2 columns
>
> Date Time     MeaValue
> 10/4/25 11:27:04 PM   43.9
> 10/4/25 11:27:05 PM   34.7
> 10/4/25 11:27:06 PM   45.4
> 10/4/25 11:27:07 PM   34.7
> 10/4/25 11:27:08 PM   34.2
>
> but in calc I get
> Date Time     MeaValue
> 10/04/25 11:27 PM     43.9
> 10/04/25 11:27 PM     34.7
> 10/04/25 11:27 PM     45.4
> 10/04/25 11:27 PM     34.7
>
> It means that the 1 second resolution is missing.
copied date and pasted in calc as tab separate fields.
Gets correct but the default date time format it uses for Column A 
is

MM/DD/YY HH:MM AM/PM

Need to highlight and change format to 
MM/DD/YY HH:MM:SS AM/PM

That will display seconds. The actual number is still same, so 
nothing was lost.

Output showing the format that includes seconds.

10/04/25 11:27:04 PM    43.9
10/04/25 11:27:05 PM    34.7
10/04/25 11:27:06 PM    45.4
10/04/25 11:27:07 PM    34.7
10/04/25 11:27:08 PM    34.2

Same Data using the number value for date/time
        
45934.9771296296        43.9
45934.9771412037        34.7
45934.9771527778        45.4
45934.9771643519        34.7
45934.9771759259        34.2


> How can I recover it?
>
> Thank.
>
> ===========================================================================
>  Patrick DUPRÉ                                 | | email: pdupre@gmx.com
> ===========================================================================
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor 
(Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 mailto:msetzerii@gmx.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy