Formula to Pull and Rearrange Values from a Cell

[tryingmybest418]

Hi all,

I have a report with cells displaying a timestamp in the format:
2018-03-05T10:07:36.794-8:00

Is there a formula I could enter that would rearrange this so that it would display in another cell as 03-05-2018 10:07?

Thank you!

 

[sheetspread]

Excel 2010
	A	B
1	2018-03-05T10:07:36.794-8:00	3/5/18 10:07
Sheet6

Cell Formulas
Range	Formula
B1	=DATE(LEFT(A1,4),MID(A1,6,2),MID(A1,9,2))+TIME(MID(A1,12,2),MID(A1,15,2),MID(A1,18,2))

=LEFT(A1,10)+MID(A1,12,8) works too