B1:=IF(MINUTE(A1)>30,TEXT(A1,"hh:mm"),"00:"&MINUTE(A1))如果等于半小时也是时数不变,用这个:=IF(MINUTE(A1)>=30,TEXT(A1,"hh:mm"),"00:"&MINUTE(A1))