Re: [libreoffice-users] lack of time resolution

It is most likely the formatting of the cells.

Open the Format Cells dialog.
(select the cell range containing the date / time values and hit Ctrl+1, 
or right-click and select Format Cells)

Go to the Numbers tab and select the desired format.

The Format Code you want is probably:   MM/DD/YY HH:MM:SS AM/PM


On 10/9/25 11:52, Patrick Dupre wrote:
> 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.
>
> 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