excel时间递增5分钟怎么设置啊? EXCEL怎么实现时间毫秒的递增?
EXCEL\u4e2d\u5982\u4f55\u8bbe\u7f6e\u65f6\u95f4\u7684\u9012\u589e\uff1f\u6750\u6599/\u5de5\u5177zxcel2007
1\u3001\u70b9\u51fb\u5355\u5143\u683c\u8f93\u5165\u4e00\u4e2a\u6570\u5b57\uff0c\u5c06\u5149\u6807\u653e\u5728\u5c0f\u9ed1\u70b9\u51fa\u4f1a\u51fa\u73b0\u4e00\u4e2a\u9ed1\u8272\u5341\u5b57\uff0c\u5355\u7eaf\u7684\u9009\u62e9\u4e0b\u62c9\u6709\u590d\u5236\u7684\u529f\u80fd
2\u3001\u70b9\u51fb\u90a3\u4e2a\u95ea\u70c1\u7684\u56fe\u6807\uff0c\u9009\u62e9\u586b\u5145\u5e8f\u5217\u4fbf\u80fd\u4ee5\u9012\u589e\u7684\u5f62\u5f0f\u586b\u5145\u5355\u5143\u683c
3\u3001\u5c06\u5149\u6807\u79fb\u5230\u5230\u5355\u5143\u683c\u7684\u53f3\u4e0b\u89d2\u5904\uff0c\u4e0b\u62c9\u5c31\u80fd\u5c06\u65f6\u95f4\u9012\u589e\u4e86
4\u3001\u5982\u82e5\u6211\u4eec\u9009\u4ee5\u6708\u4e3a\u5355\u4f4d\u586b\u5145\u7684\u8bdd\uff0c\u51fa\u6765\u7684\u6548\u679c\u5c31\u662f\u4ee5\u5e74\u4efd\u4e00\u6837\u65e5\u53f7\u76f8\u540c
5\u3001\u5728\u201c\u5f00\u59cb\u201d\u7684\u83dc\u5355\u680f\u4e2d \uff0c\u627e\u5230\u7f16\u8f91\u7684\u90a3\u4e00\u680f\u9009\u62e9\u201c\u5e8f\u5217\u201d
6\u3001\u70b9\u51fb\u201c\u5217\u201d\uff0c\u9009\u62e9\u201c\u65e5\u671f\u201d\uff0c\u5c06\u6b65\u957f\u503c\u9009\u4e3a\u201c7\u201d
7\u3001\u51fa\u6765\u7684\u65e5\u671f\u4fbf\u80fd\u4ee5\u95f4\u9694\u4e3a\u4e03\u65e5\u7684\u683c\u5f0f\u51fa\u73b0
\u5982\u4e0a\u56fe\u6240\u793a B2\u8f93\u5165\u516c\u5f0f\uff1a=TEXT(TIME(12,30,29+INT(ROW(A2)/2)),"hh:mm:ss")&"."&TEXT(RIGHT(ROW(A2)*5,1)*100,"000") \u7136\u540e\u4e0b\u62c9\uff0c\u65f6\u95f4\u662f\u4ece\uff1a12:30:30\u5f00\u59cb\u9012\u589e\uff0c\u5047\u5982\u8981\u6362\u5f00\u59cb\u65f6\u95f4\uff0c\u76f8\u5e94\u7684\u66f4\u6539\u516c\u5f0f\u4e2d\u7684\uff0c12 30 29\u5c31\u884c\uff01
首先需要确定源数据格式为时间(或日期与时间)格式。在A1输入基础时间,然后在A2输入公式=A1+5/1440即可(如图)。
把这一列选定,鼠标放在右下角边上,鼠标变成十字线,向下一拉就可以了
选中前两列,将鼠标移动到选择区域的右下角,当光标编程黑色小十字时,向下拖拽就可以了。
选中前两个单元格 下拉填充
绛旓細1. 棣栧厛锛屾墦寮Excel琛ㄦ牸骞堕夋嫨涓涓崟鍏冩牸銆2. 鍦ㄥ崟鍏冩牸涓緭鍏ヨ捣濮嬫椂闂达紝渚嬪鈥00:00:00鈥濄3. 鎺ヤ笅鏉ワ紝鍦ㄥ彟涓涓崟鍏冩牸涓緭鍏ュ叕寮忊=A1+1鈥濓紝鍏朵腑A1鏄捣濮嬫椂闂寸殑鍗曞厓鏍笺4. 鐒跺悗锛屽皢璇ュ叕寮忔嫋鍔ㄥ埌鎵闇鐨勬椂闂磋寖鍥村唴锛屼互鑷姩閫掑鏃堕棿銆5. 濡傛灉闇瑕侀殢鏈哄寲鏃堕棿锛屽彲浠ヤ娇鐢≧AND鍑芥暟鏉ョ敓鎴愰殢鏈烘暟锛屽苟灏...
绛旓細浣犻偅鏈鍚庝袱涓閲忎篃涓嶆槸3鑷5鍒嗛挓鍛锛熷厛灏咥2鍗曞厓鏍兼暟鍊肩被鍨璁剧疆涓烘棩鏈熷瀷锛屼笖鏍煎紡涓嶢1鐩稿悓锛岀劧鍚庡啀A2涓緭鍏ュ叕寮=A1+INT(RAND()*3+3)/(60*24)锛岃繖鏍锋瘡娆閫掑閲忓氨鏄3鑷5鍒嗛挓浜嗐
绛旓細=A1+TEXT(RAND()*("0:22")+"00:05:00","HH:MM:SS")
绛旓細1銆佸笇鏈涗互绉閫掑鏃堕棿锛屽彲浠3鍗曞厓鏍间腑杈撳叆浠ヤ笅鍏紡 =TEXT((TEXT(1*A2,"[s]")+1)/(24*60*60),"e-mm-dd hh:mm:ss")鐒跺悗鐒跺悗鎷栦綇濉厖鏌勫線涓嬫嫋鎷夊嵆鍙2銆佹寜鐓鍒嗛挓閫掑=TEXT((TEXT(1*A2,"[s]")+60)/(24*60*60),"e-mm-dd hh:mm:ss")3銆佹寜鐓у皬鏃堕掑=TEXT((TEXT(1*A2,"[s]...
绛旓細鍏紡涓 =A1+TIME(,ROW(A1),)鍏紡浜 =TIME(HOUR(A1),MINUTE(A1)+ROW(A1),SECOND(A1))鍏紡涓 =A1+ROW(A1)/1440 浣跨敤浠ヤ笂涓変釜鍏紡涓换涓涓叕寮忥紝璁剧疆鍗曞厓鏍兼牸寮忎负鏃堕棿鏍煎紡涓殑涓绉嶏紝鍐嶄笅鎷夊~鍏呭叕寮忋傛柟娉曚簩 鐢ㄦ搷浣滅殑鏂规硶锛氬厛鍦ㄧ涓涓崟鍏冩牸鍐欏叆涓涓椂闂 鍐嶅湪绗簩涓崟鍏冩牸鍐欏叆澧炲姞浜嗕竴鍒嗛挓鐨...
绛旓細灏嗗叕寮忔敼涓=TEXT(NOW()+TIME(0,1,0),"h:MM") A3杈撳叆锛=TEXT(TIME(HOUR(A1),MINUTE(A1)+1,SECOND(A1)),"h:MM") A5杈撳叆锛=TEXT(TIME(HOUR(A3),MINUTE(A3)+1,SECOND(A3)),"h:MM") 閫変腑A3:A5涓嬫媺鍏紡
绛旓細鍙互浣跨敤浠ヤ笅鍏紡鏉ュ疄鐜鏃堕棿閫掑30鍒嗛挓锛=鏃堕棿(HOUR(A1), ROUNDUP(MINUTE(A1)/30,0)*30, 0) + TIME(0;30,0)鍏朵腑锛孉1涓哄師濮嬫椂闂村崟鍏冩牸锛孯OUNDUP(MINUTE(A1)/30,0)*30鐢ㄤ簬灏嗗師濮嬫椂闂寸殑鍒嗛挓鏁板悜涓婂彇鏁村埌30鐨勫嶆暟锛岀劧鍚庡姞涓30鍒嗛挓鐨勬椂闂村樊銆傚埄鐢ㄦ嫋鍔ㄥ姛鑳界敓鎴愰掑鏁版嵁銆 鍏蜂綋鏂规硶锛 杈撳叆鍓2涓椂闂...
绛旓細A1鏄2008-3-12 22:08:10 A2杈撳叆鍏紡:=A1+Time(,,10)濡傛灉鏍煎紡涓嶅锛屽崟鍏冩牸鏍煎紡閲岄潰璁剧疆涓涓嬭嚜瀹氫箟鏍煎紡:yyyy-m-d hh:mm:ss
绛旓細F1杈撳叆 0:00:00 F2杈撳叆 =F1+TIME(0,15,0)鍏紡涓嬫媺
绛旓細姣斿鍦˙1鍗曞厓鏍艰緭鍏鏃堕棿锛4:10 A1鍗曞厓鏍艰緭鍏ユ椂闂达細0:10 鍦ˋ2鍗曞厓鏍艰緭鍏ュ叕寮忥細=A1+$B$1 鏈鍚庡叕寮忎笅鎷夊氨鍙互浜