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

Perfect.  Thank you,

Peter


On 6/11/21 7:21 PM, Michael D. Setzer II wrote:
> =TIME(INT(A1/100),MOD(A1,100),0)
>
>
> On 11 Jun 2021 at 19:00, Dutton wrote:
>
>
> To:users@global.libreoffice.org
> From:DuttonLook@iPadRing.net
> Subject:[libreoffice-users] LoCalc- convert a 4 
> digit number to time
> Date sent:Fri, 11 Jun 2021 19:00:39 -0400
>
>
>
>
> 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)
>
>
>
>
> 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