如下图，在A1中输入
="2016-12-31"+ROUNDUP(ROW(A1)/96,)
B1中输入
=TEXT(ROW(A1)/96-1/96,"HH:MM")&"-"&TEXT(ROW(A1)/96,"HH:MM")
选定A1:B1下拉填充。
