- a template like XLSX file (see
Template.xlsx) - openpyxl
if you have a excel file to care your working time start and end time.
run the calculator to fullfill:
- workingtime per day (end - start)
- breaktimes (german right is 30 minutes within 6 or more hours or 45 minutes within 9 or more hours)
- you can manually type in break times in the excel file the will be used, 30/45 minutes are default
- result of working time per das without breaktimes
- it's calculated for 40 hours per week (8 hours per day)
these can be changed in function
calculate diff - if keywords like 'Feiertag' or 'Urlaub' in comment the default time is set to 0
- same for 'Samstag' 'Sonntag'
- difference will be calculated in last column to see overtime per day
- sum of difference per week, and per month will be calculated in the end of each excel sheet
- sum of overall difference/overtime will be calculated and given as "Total Total" in the last line of last sheet
in my example each sheet is one month and for each week there is one table. Keywords of weekdays as well as "Stunden gesamt" are needed in first column