=TIME(INT(A1/100),MOD(A1,100),0)
On 11 Jun 2021 at 19:00, Dutton wrote: To:users@global.libreoffice.org From:duttonl...@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+unsubscr...@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+unsubscr...@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