Re: [libreoffice-users] LoCalc- convert a 4 digit number to time

Den lör 12 juni 2021 kl 01:05 skrev Dutton <Look@ipadring.net>:

> Here's what I'd like to
>         do;
>
>
> In cell A1 there's the
>         number 1230
>
>
> In cell A2 I want the
>         number to appear as 12:30 (a time figure)

If you only mean ”appear”, then just format the cell as:
00”:”00
or
#0":"00
depending on w how you want three digit numbers to appear, ”09:30” or
”9:30”.

If you are going to use the numbers for calculation as time, you have to
convert them first, though, because they only appear as time, but they are
just numbers, but you said nothing about calculating so I assume that this
is what you want.


Kind regards

Johnny Rosenberg


> Does anyone know that
>         can be done in Calc?
>
>
>
>
> Thank you,
>
>
> Peter Dutton
>
>
>
>
> --
> 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

-- 
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