On 9 Oct 2025 at 17:52, Patrick Dupre wrote:
From: Patrick Dupre <[email protected]>
To: ooffice <[email protected]>
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: [email protected]
> ===========================================================================
>
>
> --
> To unsubscribe e-mail to: [email protected]
> 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:[email protected]
mailto:[email protected]
mailto:[email protected]
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: [email protected]
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
