Time only copying as a serial number. - Microsoft Community

i'm having download information , when display excel spreadsheet, appears correctly. 00:00, or 00:00:00. 00:00 (minutes, seconds) entered in 1 cell, , added longer 1 (00:00:00). latter 1 minutes:seconds:??. (it appears 42:23:00 - means 42 minutes , 23 seconds) cells formatted custom (h:mm) first , custom [h]:mm:ss total cell. clicking in first cell, displays 13:00, see 1:00:00 pm in box above table headers. clicking in total cell, displays 31:40:00, see 1/1/1900 7:40:00 am. 

i need copy these cells , paste them word document, text other fields. using concat(). first combine fields 1 in spreadsheet. these field not contain 00:00 information, serial number. , copying word copies serial number. 

how can concatenate of text of these fields, , have keep time minutes:seconds? i'm sure programmer using add individual time fields total time field. cannot add text final combination field. if strict copy , paste of individual fields, work. there many of them way.

any on this? hope clear. (these lengths of music pieces, totaled length of entire program.) -

hi tbirdroy,

 

concat function used combine text multiple ranges and/or strings. if want keep format, i'd suggest use text function. here screenshot of simple sample:

 

regards,

zixuan

Office / Excel / Mac / Office 2016 for Mac