How to convert a text string into hours
===

I have data in the format as d.hh.mm.ss and hh.mm.ss and I need to conver both into a time value of HH.MM.SS

In A1 the text string is 16.21:38:27
in A2 the text string is    04:08:45

My resulting cell should show B1 405:38:27
                              B2  04:08:45

I have tried using  =LEFT(A1,SEARCH(":",A1)-1)+TIMEVALUE(MID(A1,SEARCH(":",A1)+1,255))
but the results are wrong
A1 is shown as 403:29:24
A2 is shown as 104:45:00 

I would like one formula for both strings