concat function

how can merge 2 column together:

column time1 with text as 00:41
column time2 with text as 27

how can i merge it into a single cell in hh:mm:ss format , 00:41:27 ?

thanks.

try

=--(A1&":"&B1)

where A1 = time1 and B1 = time2

or if A1 is a time value you could just do

=A1+TIME(0,0,B1)

thanks, 2nd option work.