半小时拆分时间段 (10887)

B2:F3=IF(COLUMN(A1)>(LOOKUP(1,RIGHTB($A2,{4,5})*1)-IMREAL($A2&"i"))*48,"",TEXT(IMREAL($A2&"i")+(COLUMN(A1)-1)/48,"H:MM-")&TEXT(IMREAL($A2&"i")+COLUMN(A1)/48,"H:MM"))

另解=IF(COLUMN(A1)>(LOOKUP(1,RIGHTB($A2,{4,5})*1)-TEXT(,"[$"&$A2&"]"))*48,"",TEXT(TEXT(,"[$"&$A2&"]")+(COLUMN(A1)-1)/48,"H:MM-")&TEXT(TEXT(,"[$"&$A2&"]")+COLUMN(A1)/48,"H:MM"))

另解=IF(COLUMN(A1)>(LOOKUP(1,RIGHTB($A2,{4,5})*1)-LOOKUP(1,LEFTB($A2,{4,5})*1))*48,"",TEXT(LOOKUP(1,LEFTB($A2,{4,5})*1)+(COLUMN(A1)-1)/48,"H:MM")&"-"&TEXT(LOOKUP(1,LEFTB($A2,{4,5})*1)+COLUMN(A1)/48,"H:MM"))

另解=IF(COLUMN(A1)<=-IMREAL(IMDIV($A2&"i","1+i"))*96,TEXT(IMREAL($A2&"i")+(COLUMN(A1)-1)/48,"h:mm-")&TEXT(IMREAL($A2&"i")+COLUMN(A1)/48,"h:mm"),"")