随机生成时间间隔 (10279)

B1=("15:30:30"-"7:00")*86400/35

下拉35格 D2=RANDBETWEEN(MAX(B$3,B$1*B$4-SUM(D$1:D1)-(B$4-ROW(A1))*B$2),MIN(B$1*B$4-SUM(D$1:D1)-(B$4-ROW(A1))*B$3,B$2))

下拉35格 E2=SUM(D$2:D2)/86400+"7:00"

G2=SUM(D:D)