Google sheets - team time log system creation

Hello,

I require a Google Sheets expert to create me a system to track staff time and annual leave on weekly basis and then from this create monthly summary reports in CSV file to upload to our payroll software.

The data for the monthly summary will be in 2 spreadsheets. You will need some macro experience to make it easy to add new sheets and carry out routine tasks for the operator to minimise errors.

1. Staff time log - input weekly in/out hours (see example I've started that needs adapting/added to) https://docs.google.com/spreadsheets/d/1bmvb7dBnieubRKOV7QMM_19GyF-UDsni2ZNapVjieIs/edit?usp=gmail

2. Staff database - store staff details (pay rate/name/NI number etc). The names from here will be fed to the time tracking sheet above.

Each month the time tracking data will need to be exported into a certain format, in CSV format.