Hi,
Could somebody help me how to find out the total hours is 36:27 in(cell C7)?
thank you for help.
gigi
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
Could somebody help me how to find out the total hours is 36:27 in(cell C7)?
thank you for help.
gigi
A | B | C | |
1 | start | finish | hours |
2 | 9:00 | 16:30 | 7:30 |
3 | 9:05 | 16:25 | 7:20 |
4 | 9:25 | 17:35 | 8:10 |
5 | 9:20 | 16:00 | 6:40 |
6 | 9:15 | 16:02 | 6:47 |
7 | total: |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>