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>
