Following Alan's description, you can also try:Formula:
=SUBSTITUTE(SUBSTITUTE(A6,"Z",""),"T"," ")+0
formatted asFormula:
yyyy-mm-dd hh:mm:ss
Following Alan's description, you can also try:Formula:
=SUBSTITUTE(SUBSTITUTE(A6,"Z",""),"T"," ")+0
formatted asFormula:
yyyy-mm-dd hh:mm:ss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks