Hi
I have the following information of contractors of internal and external staff and when the sheet comes to me i get thousands of lines but i need to total the columns up into Days, Hours,Minutes but i need a little help with converting the cells because there is so much i need to change the way the cell shows its info, ive attached file to show my problem
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
I have the following information of contractors of internal and external staff and when the sheet comes to me i get thousands of lines but i need to total the columns up into Days, Hours,Minutes but i need a little help with converting the cells because there is so much i need to change the way the cell shows its info, ive attached file to show my problem
Arrivel Time | Departure Time | Total hrs int | Total hrs ext |
13/12/2018 14:29 | 13/12/2018 15:49 | 1h 20min | 1h 20min |
13/12/2018 14:21 | 13/12/2018 16:08 | 1h 46min | |
13/12/2018 12:54 | 13/12/2018 14:29 | 1h 34min | 1h 34min |
Total | ? | ? |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>