AngelicaWan
New Member
- Joined
- Aug 20, 2015
- Messages
- 8
Hi everyone,
I got an urgent question about accumulating large time. Please help!
Is there any way to sum up 3 time in each row from A3:C6? The data format is General which I copied from other data source. The time in this table means dd:hh:mm:ss. They could not be calculated even if I change the data format to custom -> dd:hh:mm:ss.
Thanks in advance!
[TABLE="width: 192"]
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"]I[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]II[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]III[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]Sum[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]17:04:02:02[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:24[/TD]
[TD="class: xl66, bgcolor: transparent"]2:23:27:40[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:20:13:08[/TD]
[TD="class: xl68, bgcolor: transparent"]0:00:18[/TD]
[TD="class: xl66, bgcolor: transparent"]09:28:35[/TD]
[TD="class: xl67, bgcolor: yellow"]=A3+B3+C3[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:07:24:14[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:00[/TD]
[TD="class: xl66, bgcolor: transparent"]07:10:51[/TD]
[TD="class: xl67, bgcolor: yellow"]=A4+B4+C4[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:13:33:32[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:00[/TD]
[TD="class: xl66, bgcolor: transparent"]22:09:26[/TD]
[TD="class: xl67, bgcolor: yellow"]=A5+B5+C5[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]3:10:51:08[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:06[/TD]
[TD="class: xl66, bgcolor: transparent"]1:08:38:48[/TD]
[TD="class: xl67, bgcolor: yellow"]=A6+B6+C6[/TD]
[/TR]
</tbody>[/TABLE]
I got an urgent question about accumulating large time. Please help!
Is there any way to sum up 3 time in each row from A3:C6? The data format is General which I copied from other data source. The time in this table means dd:hh:mm:ss. They could not be calculated even if I change the data format to custom -> dd:hh:mm:ss.
Thanks in advance!
[TABLE="width: 192"]
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>[TR]
[TD="class: xl65, width: 64, bgcolor: white"]I[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]II[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]III[/TD]
[TD="class: xl65, width: 64, bgcolor: white"]Sum[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]17:04:02:02[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:24[/TD]
[TD="class: xl66, bgcolor: transparent"]2:23:27:40[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:20:13:08[/TD]
[TD="class: xl68, bgcolor: transparent"]0:00:18[/TD]
[TD="class: xl66, bgcolor: transparent"]09:28:35[/TD]
[TD="class: xl67, bgcolor: yellow"]=A3+B3+C3[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:07:24:14[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:00[/TD]
[TD="class: xl66, bgcolor: transparent"]07:10:51[/TD]
[TD="class: xl67, bgcolor: yellow"]=A4+B4+C4[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]4:13:33:32[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:00[/TD]
[TD="class: xl66, bgcolor: transparent"]22:09:26[/TD]
[TD="class: xl67, bgcolor: yellow"]=A5+B5+C5[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]3:10:51:08[/TD]
[TD="class: xl66, bgcolor: transparent"]00:00:06[/TD]
[TD="class: xl66, bgcolor: transparent"]1:08:38:48[/TD]
[TD="class: xl67, bgcolor: yellow"]=A6+B6+C6[/TD]
[/TR]
</tbody>[/TABLE]