Re: [libreoffice-users] split 4 digits to time macro

If you are going to do search and replace, it's very tricky if your cells
has values from 1 up to 4 digits, such as 5 for 0:05 and 1500 for 15:00.
Here's another way to do it:
In a free column, first row, enter (if your values are in the A column):
=INT(A1/100)/24+(A1-INT(A1/100)*100)/1440
This converts your number to a fraction of a day (600=0.25, 1200=0.5,
1800=0.75 and so on). Then you just format the column to HH:MM. As a last
step, just copy the whole column as values to the A column:
Shift+Ctrl+v
☐ All
☐ Numbers
☐ Text
☒ date & time
☒ Formats
☐ Comments
☐ Objects
☐ Formulas
Click OK.

Kind regards

Johnny Rosenberg



> On Mar 15, 2025, 4:08 PM, at 4:08 PM, James <bjlockie@lockie.ca> wrote:
> > I'll try the find and replace.
> > Thanks.
> >
> > --
> > 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