EXCEL时间求和,求出来总是00；00；00连接时长01:15:2100:04:3900:02:1500:27:0000:45:3701:09:3600:07:3900:21:4200:16:5800:09:1100:36:0000:03:5900:11:2900:05:3500:21:5601:04:2900:04:5100:01:4000:09:3000:07:0100:03:0000:07:2300:31:4700:55:4100:02:0800:26:5700:30:2600:04:4800:21:1800:01:5500:00:5900:18:4400:21:4900:17:3700:01:1601:08:1300:19:1800:01:4100:19:1000:06:1701:48:4701:07:0402:07:3800:13:1400:02:0600:45:0100:09:0400:03:0800:15:1600:02:0900:34:0400:40:2700:01:3000:07:0400:15:3200:11:0100:01:4700:23:5900:07:2900:27:2200:03:3800:02:5200:34:3900:12:4000:12:0100:02:1900:11:3600:03:1900:06:5300:05:5900:14:0200:11:4000:06:3900:07:5900:03:5700:00:1500:11:1600:03:1900:20:4700:03:1901:15:5000:18:1500:17:2000:07:0800:09:0600:13:3600:00:4800:02:1100:00:0700:00:4800:11:3600:24:2400:01:0100:02:1500:03:3900:02:3900:02:0000:06:0000:13:2000:07:2000:05:2000:08:4000:08:0000:08:2100:13:2000:03:2000:29:4000:10:5200:09:0000:08:1900:06:0000:08:1700:04:2000:09:3900:01:5900:04:4100:13:5901:40:0200:11:5900:03:5900:05:2000:09:2000:01:4800:04:4000:02:4000:12:0100:04:0000:52:2000:13:2000:02:4200:02:590:00:00
网友回答
【答案】 如果你的数据在A列用以下公式:
=TEXT(SUM(A:A),[hh]:mm:ss)
如果还不行,输入:
=TEXT(SUM(--A:A),[hh]:mm:ss)
同时按CTRL+SHIFT+ENTER结束输入即可