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

=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