Nicolás Adamo wrote
concatenating strings is always handy: A1: 8 B1: 15 C1: =a1 & ":" & b1
If you actually need to use this as time you should do c1=VALUE(a1 & ":" & b1). This will show up as 0.34375. Format this cell as Time and voilà :) Please notice that both this method and the TIME function will convert values 8 and 15 to 8:15 of December 30th of 1899 (i.e. default day 1 for LibreOffice as defined in Tools, Options, LibreOffice Calc, Calculate, Date), not 8:15 of the current day! -- View this message in context: http://nabble.documentfoundation.org/numbers-to-time-tp3761479p3762256.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@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/ All messages sent to this list will be publicly archived and cannot be deleted