I didn't knew the time function, but if you do not need to operate with the result (i.e. add 8 minutes to 8:15 so as to obtain 8:23 BTW remember that time units are days, so to add 8 minutes you have to divide by 24 and then by 60) concatenating strings is always handy: A1: 8 B1: 15 C1: =a1 & ":" & b1 Regards, Nicolás 2012/2/20 Nino Novak <nn.libo@kflog.org>:
On Monday 20 February 2012, James wrote:I have two cells, one with the number 8 and one with the number 15. I want to combine them into a time cell, 8:15.A1: 8 A2: 15 A3: =TIME(A1;A2;0) You might have to choose the appropriate format (Format > Cells > Number) for the cell. Regards, Nino -- 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
-- 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