Excel使用总结

=TEXT(I2/60/24,"d天h小时m分")

前为分钟，后为格式化

41,031	28天11小时51分
5,862	4天1小时42分

字符串拼接

="INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '"&INDIRECT("C"&ROW())&"', "&INDIRECT("B"&ROW())&", 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');"

INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '石油', 10010001, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010001	石油
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '钢铁', 10010002, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010002	钢铁
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '稀土', 10010003, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010003	稀土
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '泰矿', 10010004, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010004	泰矿
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '宝石', 10010005, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010005	宝石
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '1级步兵', 10010101, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010101	1级步兵
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '2级步兵', 10010102, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010102	2级步兵
INSERT INTO item (id, name, item_id, app_id, add_time, modify_time) VALUES (null, '3级步兵', 10010103, 1, '2022-11-01 21:13:21', '2022-11-01 21:13:21');	10010103	3级步兵