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!
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>
</tbody>
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!
I | II | III | Sum |
17:04:02:02 | 00:00:24 | 2:23:27:40 | |
4:20:13:08 | 0:00:18 | 09:28:35 | =A3+B3+C3 |
4:07:24:14 | 00:00:00 | 07:10:51 | =A4+B4+C4 |
4:13:33:32 | 00:00:00 | 22:09:26 | =A5+B5+C5 |
3:10:51:08 | 00:00:06 | 1:08:38:48 | =A6+B6+C6 |
<colgroup><col style="width: 48pt;" span="4" width="64">
<tbody>
</tbody>