![]() |
create calendar with only M-F and add multiple repeating events
Excell 2002.
I want to create an office task calendar. The tasks would be recurring events. The recurrent rate would be based upon the number of people who can do the task. There would be three different tasks, each with its own rate of recurrence. I want to create a work week calendar that only contains monday through friday, as I've found trying to work with the inclusion of saturday and sunday really reeks havoc when trying to coordinate a recurrent event based on a five day week into a seven day week. Eliminating the weekends in the calculation would seem to simplify things. The format of the calendar should be easily read by workers in cubicles. And, hopefully, the recurring event need only be entered once and maybe easily edited if need be. --johnp |
create calendar with only M-F and add multiple repeating events
Hi John
Have a look at this website, you should be able to find something you can use and modify to your needs. If you need held with functions or formulas just post again, someone will gladly help you. HTH Cimjet http://office.microsoft.com/en-us/te...s/default.aspx "johnp" wrote in message ... Excell 2002. I want to create an office task calendar. The tasks would be recurring events. The recurrent rate would be based upon the number of people who can do the task. There would be three different tasks, each with its own rate of recurrence. I want to create a work week calendar that only contains monday through friday, as I've found trying to work with the inclusion of saturday and sunday really reeks havoc when trying to coordinate a recurrent event based on a five day week into a seven day week. Eliminating the weekends in the calculation would seem to simplify things. The format of the calendar should be easily read by workers in cubicles. And, hopefully, the recurring event need only be entered once and maybe easily edited if need be. --johnp |
All times are GMT +1. The time now is 01:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com