Hi all,

Our company works around a four week pattern;

Sun Mon Tue Wed Thu Fri Sat
0 7.5 9.5 9.5 7.5 0 0
0 9.5 0 0 7.5 7.5 7.5
0 0 9.5 9.5 9.5 9.5 0
0 7.5 9.5 7.5 0 0 7.5

What can I do to automate the repetition of this pattern on a work rota,
I have a rota with months to a row under each day of the week i need to show
the work hours as above, but then to repeat itself, a month may end mid week,
so the following month needs to pick up the pattern where that last month
ended.

Tried to search for a similar question/reply without luck.

Thanks for taking time to read this, and any help is appricated.

Regards.

I'm afraid I don't quite understand how your worksheet is currently
setup, but you might be able to modify the formula below to meet your
needs
It assumes that the days are in Column A like
A1 Sun
A2 Mon
A3 Tue
..
..
..
=INDEX({0,7.5,9.5,9.5,7.5,0,0},MATCH(A1,
{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"},0))
If you fill this formula down, it will tell you how many hours were
worked for each of the matching days. You'll have to expand the array
(the part enclosed between {}) to get the 28 items you want).
There is probably a 'nicer' equation that you could use, but I'm
afraid that I am not really sure how your workbook is setup, so I'm
not sure how you would want to do it.

You could also put that data in a table somewhere and use a HLookup
function to match the day with the hours (in my example, the table is
I1:O5 ("Sun" in I1)).
=HLOOKUP(I$1,$I$1:$O$5,1,FALSE) will return "Sun", if you change it to
=HLOOKUP(I$1,$I$1:$O$5,2,FALSE) it will return 0, and =HLOOKUP(J$1,$I
$1:$O$5,2,FALSE) will return 7.5

If these suggestions were not helpful (or does not work), feel free to
email me an example of the workbook (or even just a picture of the
workbook) so I can visualize what you are trying to do, and hopefully
help.
Take care,

On Mar 9, 9:20 am, LaDdIe wrote:
Hi all,

Our company works around a four week pattern;

Sun Mon Tue Wed Thu Fri Sat
0 7.5 9.5 9.5 7.5 0 0
0 9.5 0 0 7.5 7.5 7.5
0 0 9.5 9.5 9.5 9.5 0
0 7.5 9.5 7.5 0 0 7.5

What can I do to automate the repetition of this pattern on a work rota,
I have a rota with months to a row under each day of the week i need to show
the work hours as above, but then to repeat itself, a month may end mid week,
so the following month needs to pick up the pattern where that last month
ended.

Tried to search for a similar question/reply without luck.

Thanks for taking time to read this, and any help is appricated.

Regards.

Thanks Meatshield,

I've emailed a stripped copy of my project to show what I trying to achive.

Thanks for your time.

"meatshield" wrote:

I'm afraid I don't quite understand how your worksheet is currently
setup, but you might be able to modify the formula below to meet your
needs
It assumes that the days are in Column A like
A1 Sun
A2 Mon
A3 Tue
..
..
..
=INDEX({0,7.5,9.5,9.5,7.5,0,0},MATCH(A1,
{"Sun","Mon","Tue","Wed","Thu","Fri","Sat"},0))
If you fill this formula down, it will tell you how many hours were
worked for each of the matching days. You'll have to expand the array
(the part enclosed between {}) to get the 28 items you want).
There is probably a 'nicer' equation that you could use, but I'm
afraid that I am not really sure how your workbook is setup, so I'm
not sure how you would want to do it.

You could also put that data in a table somewhere and use a HLookup
function to match the day with the hours (in my example, the table is
I1:O5 ("Sun" in I1)).
=HLOOKUP(I$1,$I$1:$O$5,1,FALSE) will return "Sun", if you change it to
=HLOOKUP(I$1,$I$1:$O$5,2,FALSE) it will return 0, and =HLOOKUP(J$1,$I
$1:$O$5,2,FALSE) will return 7.5

If these suggestions were not helpful (or does not work), feel free to
email me an example of the workbook (or even just a picture of the
workbook) so I can visualize what you are trying to do, and hopefully
help.
Take care,

On Mar 9, 9:20 am, LaDdIe wrote:
Hi all,

Our company works around a four week pattern;

Sun Mon Tue Wed Thu Fri Sat
0 7.5 9.5 9.5 7.5 0 0
0 9.5 0 0 7.5 7.5 7.5
0 0 9.5 9.5 9.5 9.5 0
0 7.5 9.5 7.5 0 0 7.5

What can I do to automate the repetition of this pattern on a work rota,
I have a rota with months to a row under each day of the week i need to show
the work hours as above, but then to repeat itself, a month may end mid week,
so the following month needs to pick up the pattern where that last month
ended.

Tried to search for a similar question/reply without luck.

Thanks for taking time to read this, and any help is appricated.

Regards.