Convert a ISO date to date in Excel - My second brain

``` =DATEVALUE(MID(A1,1,10))+TIMEVALUE(MID(A1,12,8)) ```