Den fre 17 juli 2020 kl 14:39 skrev Gilles <codecomplete@free.fr>:
Hello, I have a spreadsheet where time is formatted as HHhMM. In the next column, I'd like to show this in minutes. What would be a good way to achieve this? Thank you.
The quickest way I can think of is to just use the same value and format it to show minutes only. An example: A1 Input: 12:34:56 Format: HH:MM Result: 12:34 B1: Formula: =A1 Format: [MM] Result: 754 So same value, but formatted as [MM]. Don't forget the []. This won't work if the values are in text format, of course. Kind regards Johnny Rosenberg
https://i.postimg.cc/qRKCK14F/image.png -- Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html -- 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
