Hi
I created an annual timesheet some time ago and its great, but occasionally the formulas fail and the calculations are off in particular the hh:mm and [hh:mm] which seems to act differently on different sheets! As all of the team have individual workbooks (sheet per month) I then have to check and correct each one. There are varying contracted hours across the team.
I need to be able to record
Upto 3 start and finish times per day, 7 days a week
Sickness and leave hours
It needs to calculate total hours worked per day - also weekly lieu time which also needs to be carried forward.
I just need a simple to use template but the ones I have found don't really do what I need, does anyone have any suggestions for one that will work for me?
I created an annual timesheet some time ago and its great, but occasionally the formulas fail and the calculations are off in particular the hh:mm and [hh:mm] which seems to act differently on different sheets! As all of the team have individual workbooks (sheet per month) I then have to check and correct each one. There are varying contracted hours across the team.
I need to be able to record
Upto 3 start and finish times per day, 7 days a week
Sickness and leave hours
It needs to calculate total hours worked per day - also weekly lieu time which also needs to be carried forward.
I just need a simple to use template but the ones I have found don't really do what I need, does anyone have any suggestions for one that will work for me?
