EXCEL 将日期和时间分开显示

1, =TEXT(A1,"yyyy/mm/dd")2,=TEXT(A1,"HH:MM")&"-"&TEXT(A1+1/48,"HH:MM")