Thanks! That's awesome! I won't have to learn adding more functions/steps in the pipedream. I combined the formula, converted to Pacific daylight savings time zone and now I got the time.
=>>>> =(((((LEFT(A2,10) & "." & RIGHT(A2,3))-7*60*60)/60)/60)/24)+DATE(1970,1,1)