ok let me try it

No it doesn’t work, I have tried that and the problem is when I use the formula the answer it gives is 1:12:25 and it should show 1:21:00. I will re draft my question

Hi I want to work out the following sum. For every hour somebody works at my company they earn 12.07% of a hour toward their holiday allowance and I don't know what sum/formula to use.

I know that for example if some body works for 10 hour they are entitled to 1.21 hours of holiday time off.

At present I have a excel work sheet that works out total hours worked in a month, the cell this appears in is formatted to Custom [h]:mm:ss. What I want is the completed sum so I can cut and paste it into the relevant box so if cell A1 has total hours work in the month I want cell B1 to have the total amount of hours earned toward paid holiday leave.

Casual or irregular working patterns

If you work casually or irregular hours it may well be easiest to calculate the holiday entitlement that accrues (accumulates) as hours are worked. The holiday entitlement of 5.6 weeks is equivalent to 12.07 per cent of the hours you worked. The 12.07 per cent figure is:

5.6 weeks' holiday, divided by 46.4 weeks (being 52 weeks - 5.6 weeks) multiplied by 100 = 12.07 per cent

The 5.6 weeks have to be excluded from the calculation as you would not be present during the 5.6 weeks in order to accrue annual leave. For example, if you had worked 10 hours, you would be entitled to 72.6 minutes' paid holiday:

12.07 per cent x 10 hours = 1.21 hours = 72.6 minutes

The holiday entitlement is just over seven minutes for each hour worked.

This is what i am basically trying to do but in a excel work sheet Casual or irregular working patterns

If you work casually or irregular hours it may well be easiest to calculate the holiday entitlement that accrues (accumulates) as hours are worked. The holiday entitlement of 5.6 weeks is equivalent to 12.07 per cent of the hours you worked. The 12.07 per cent figure is:

5.6 weeks' holiday, divided by 46.4 weeks (being 52 weeks - 5.6 weeks) multiplied by 100 = 12.07 per cent

The 5.6 weeks have to be excluded from the calculation as you would not be present during the 5.6 weeks in order to accrue annual leave. For example, if you had worked 10 hours, you would be entitled to 72.6 minutes' paid holiday:

12.07 per cent x 10 hours = 1.21 hours = 72.6 minutes

The holiday entitlement is just over seven minutes for each hour worked.

This is what I want to do but in a excel sheet. This info is of my goverments website Casual or irregular working patterns

If you work casually or irregular hours it may well be easiest to calculate the holiday entitlement that accrues (accumulates) as hours are worked. The holiday entitlement of 5.6 weeks is equivalent to 12.07 per cent of the hours you worked. The 12.07 per cent figure is:

5.6 weeks' holiday, divided by 46.4 weeks (being 52 weeks - 5.6 weeks) multiplied by 100 = 12.07 per cent

The 5.6 weeks have to be excluded from the calculation as you would not be present during the 5.6 weeks in order to accrue annual leave. For example, if you had worked 10 hours, you would be entitled to 72.6 minutes' paid holiday:

12.07 per cent x 10 hours = 1.21 hours = 72.6 minutes

The holiday entitlement is just over seven minutes for each hour worked.

This is what i am trying to do but in a excel format, The below infor is from my goverments website Casual or irregular working patterns

If you work casually or irregular hours it may well be easiest to calculate the holiday entitlement that accrues (accumulates) as hours are worked. The holiday entitlement of 5.6 weeks is equivalent to 12.07 per cent of the hours you worked. The 12.07 per cent figure is:

5.6 weeks' holiday, divided by 46.4 weeks (being 52 weeks - 5.6 weeks) multiplied by 100 = 12.07 per cent

The 5.6 weeks have to be excluded from the calculation as you would not be present during the 5.6 weeks in order to accrue annual leave. For example, if you had worked 10 hours, you would be entitled to 72.6 minutes' paid holiday:

12.07 per cent x 10 hours = 1.21 hours = 72.6 minutes

The holiday entitlement is just over seven minutes for each hour worked.

Sorry Yes, under category i have used the Custom for mate [H]:mm:ss for all the data contain times

30:00:00 and if they worked 12 hours 13 min 23 sec it would show as 12:13:23

Ok Should i stay on line?

ok

whats your question

Not total sure what you mean. On my sheet i have a start time say 08:00:00 then a finish time say 16:30 the sheet then works out the total hours, in this case 8:30:00. There is a line for each day so at the end of the week it gives a total hours work in the week all this formats are in the [H]:mm:ss

I cn e-mail you the sheet to look at if you want

Sorry i Can

Just signing up now

Hi i have tried but it uploads the crashes!!!

No Tomorrow is good for me it 3.47am here so best get to bed myself

Hi, Sorry but the sum doesn't work. When you use it to calculate the 10 hours allowance its spot on but when you use it to calculate 1 hour its wrong. I don't know if we are coming at it the wrong way. The basic figures behind the sum are this

for every 1 hour you work you accrue 7minutes 26seconds of holiday. The sum needs to work out the following i have a box with the total hours worked for the sake of the sum lets say 1 hour (box format for total hours is [H]:mm:ss). The sum i am after needs to look at this box with the total hours in and add 00:07:62 second for every hour shown giving me a total amount of holiday entitlement earned. When you come back on line see what you can do and i will check in later.

Yes, 10 hours should should 72.6 minutes of holiday