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