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 <bjloc...@lockie.ca> wrote: > >I'll try the find and replace. > >Thanks. > > > >-- > >To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > >Problems? > >http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > >Posting guidelines + more: > >http://wiki.documentfoundation.org/Netiquette > >List archive: http://listarchives.libreoffice.org/global/users/ > >Privacy Policy: http://www.documentfoundation.org/privacy > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ Privacy Policy: http://www.documentfoundation.org/privacy
