I've created the attached time sheet for work(the print & email buttons don't work yet) which will be used for a complete year (i've only added January and February so far).
Flexi/Toil is automatically carried over to following month including any negative hours (hours owed). As the template will be set up for an individual at the start of each year there may be the need to manually carry flexi/toil over from previous year which is fin if it's a plus value but i cannot manually enter a negative value into cell K6 in January - can anyone help please?
I've attached the time sheet so anyone can download/use it if it's of any use to them too (it will just need January copied into new tabs for remaining months). Only cells shaded grey need to be filled in and the the time sheet has the functions listed below:
works out daily hours to be worked
toil/flexi carried over to each week/month
non working weeks not taken into account/previous toils carries over
cell backgrounds changes to green or red if actual hours worked or more or less than contracted hours (easy for HR Admin to spot at a glance)
I f anyone can help me with the negative value issue in January that would be great
Thank you