JakkeJakobsen
Board Regular
- Joined
- Sep 10, 2014
- Messages
- 94
Hi! I collect all the data (using Google Sheets, so it is all connected and cloud-based) from my employees' timesheets into one. The reason is to see where there are holes in the timesheets, and to see who worked when in an easy way (we got set shifts that doesn't need a schedule).
Now, I got date, start and stop times for each person like this, sorry for this being in Norwegian, no way around that I'm afraid:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 41px"><col width="77"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"></colgroup><tbody>
</tbody><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Now, what I want, is to fill this somehow, automatically:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 41px"><col width="77"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"></colgroup><tbody>
</tbody>
Now, I got date, start and stop times for each person like this, sorry for this being in Norwegian, no way around that I'm afraid:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Lør | 16/12/2017 | ||||||
Søn | 17/12/2017 | ||||||
Man | 18/12/2017 | 17:00 | 22:00 | ||||
Tirs | 19/12/2017 | 17:00 | 22:00 | ||||
Ons | 20/12/2017 | ||||||
Tors | 21/12/2017 | ||||||
Fre | 22/12/2017 | ||||||
Lør | 23/12/2017 | ||||||
Søn | 24/12/2017 | ||||||
Man | 25/12/2017 | ||||||
Tirs | 26/12/2017 | ||||||
Ons | 27/12/2017 | ||||||
Tors | 28/12/2017 | 17:00 | 22:00 | ||||
Fre | 29/12/2017 | 15:00 | 23:00 | ||||
Lør | 30/12/2017 | ||||||
Søn | 31/12/2017 | ||||||
Man | 01/01/2018 | ||||||
Tirs | 02/01/2018 | 17:00 | 22:00 | ||||
Ons | 03/01/2018 | 17:00 | 22:00 | ||||
Tors | 04/01/2018 | 17:00 | 22:00 | ||||
Fre | 05/01/2018 | 17:00 | 21:00 | 21:00 | 00:00 |
<colgroup><col style="width: 41px"><col width="77"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"></colgroup><tbody>
</tbody>
Now, what I want, is to fill this somehow, automatically:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Dag | Dato | 09:00 | 10:00 | 11:00 | 12:00 | 13:00 | 14:00 | 15:00 | 16:00 | 17:00 | 18:00 | 19:00 | 20:00 | 21:00 | 22:00 | 23:00 | 00:00 | 01:00 | 02:00 | 03:00 | 04:00 | 05:00 | 06:00 | 07:00 | 08:00 |
Lør | 16/12/2017 | ||||||||||||||||||||||||
Søn | 17/12/2017 | ||||||||||||||||||||||||
Man | 18/12/2017 | ||||||||||||||||||||||||
Tirs | 19/12/2017 | ||||||||||||||||||||||||
Ons | 20/12/2017 | ||||||||||||||||||||||||
Tors | 21/12/2017 | ||||||||||||||||||||||||
Fre | 22/12/2017 | ||||||||||||||||||||||||
Lør | 23/12/2017 | ||||||||||||||||||||||||
Søn | 24/12/2017 | ||||||||||||||||||||||||
Man | 25/12/2017 | ||||||||||||||||||||||||
Tirs | 26/12/2017 | ||||||||||||||||||||||||
Ons | 27/12/2017 | ||||||||||||||||||||||||
Tors | 28/12/2017 | ||||||||||||||||||||||||
Fre | 29/12/2017 | ||||||||||||||||||||||||
Lør | 30/12/2017 | ||||||||||||||||||||||||
Søn | 31/12/2017 | ||||||||||||||||||||||||
Man | 01/01/2018 | ||||||||||||||||||||||||
Tirs | 02/01/2018 | ||||||||||||||||||||||||
Ons | 03/01/2018 | ||||||||||||||||||||||||
Tors | 04/01/2018 | ||||||||||||||||||||||||
Fre | 05/01/2018 |
<colgroup><col style="width: 41px"><col width="77"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"><col width="50"></colgroup><tbody>
</tbody>