LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 131
Default Recurring pattern

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum of every 6th column and recurring Pierian Spring Excel Worksheet Functions 3 January 17th 07 05:55 PM
Recurring Titles Don Excel Discussion (Misc queries) 2 June 26th 06 05:58 PM
recurring anniversary dates Blackhawk Excel Discussion (Misc queries) 0 August 2nd 05 06:21 AM
recurring dates sonoundio Excel Discussion (Misc queries) 1 May 24th 05 01:53 AM
HELP! monthly recurring revenue DigtalMe Excel Worksheet Functions 0 November 23rd 04 08:27 PM


All times are GMT +1. The time now is 07:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"