求助，如何在两个体育成绩中生成随机数？如3′55″-4′40″

推荐用辅助单元格，不用的话就这样写：=INT(RANDBETWEEN(LEFT("3'55""",FIND("'","3'55""")-1)*60+MID("3'55""",FIND("'","3'55""")+1,FIND("""","3'55""")-FIND("'","3'55""")-1),LEFT("4'40""",FIND("'","4'40""")-1)*60+MID("4'40""",FIND("'","4'40""")+1,FIND("""","4'40""")-FIND("'","4'40""")-1))/60)&"'"&MOD(RANDBETWEEN(LEFT("3'55""",FIND("'","3'55""")-1)*60+MID("3'55""",FIND("'","3'55""")+1,FIND("""","3'55""")-FIND("'","3'55""")-1),LEFT("4'40""",FIND("'","4'40""")-1)*60+MID("4'40""",FIND("'","4'40""")+1,FIND("""","4'40""")-FIND("'","4'40""")-1)),60)&""""

使用辅助单元格就是这样

转换成秒，产生数据，再转换回来。