Help with my timesheet to calculate accrued holiday

[jambo2013]

Dear excel forum,

Apologies if this is in the wrong thread.

I'm currently a temp working, working via an agency so have to submite sheets weekly. Now according to the agency I accrue about 4.5 hours of holiday for every week worked (So every 5 days)

I'm kind of struggling to devise a way to calculate and show what holiday time i have accrued to date in excel. (as i keep an electronic copy of all my timesheets)

I would like to be able to list for each day time in, time out, lunch break time, total hours worked in the day, how much leave that day has accrued and then seperately show total holiday accrued (In days and hours) minus what holiday I have taken.

Could anyone advise on how I could go about this? Even if you advise on what forumale or formatting I should use would be greatly appreciated.

Ive attached what I use so far and here is a snippit of how my timesheets look.

timesheet snippit.jpg

Thank You
Jambo2013

[x65140]

Maybe you can work with this....

[jambo2013]

Wow this is pretty much exactly what I need. A few minutes before you replied I think I worked it out, but yours is really nice.

In the holiday accrued section, what does 0.90 represent in hrs/mins ?
I'm struggling to get an answer from my recruitment agency about how much holiday I earn either daily/hourly - all they say it 'we have systems that track this, all i can tell you it works it out as an average'

Thank you very much for this

Jambo2013

[x65140]

you mentioned that you get 4.5 hours per the 5 days...so that is .9 hours (:54 minutes) each day.

[jambo2013]

thank you for this. It's really helpful. All i need to do now is use a formula to calculate the amount of holiday I earn per day ensuring to cap each day to a maximum of 54mins
Thank you for your help with this