Hi all,
I just got a job as a manager in a shop, part of my job is to organize a rota. I do this, but the old rota is crude and time consuming... so i made a new one.
What i really wanted is not only to have a start/stop time but have the hours clocked up in that shift, then to take 30 mins off for break.
Then to add the total hours so i can lazily check i haven't given out overtime inadvertently.
I have done all of this but with errors. I got the times and hours worked sorted, then the breaks taken off (after i found that 0.020833 is 30 mins).
The problem i have is when i add them all up i dont get the right total. I think it is because I have left 2 shifts blank (resulting in #####) for the rest days coz they differ week from week.
So is there a way of getting rid of this #### without having to change the code week by week.
I have attached a shorter version for you to look at, please dont do the work for me but tell me how to do it myself (or how can i learn?)
Thanks in advance
Jaffa
Bookmarks