If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
work schedule again
Hey there,
I'm looking all over the web for a template which suits about 12 employees. They work sometimes split and double shifts (and me 24/7). I thought it automatically inserts the date for each day, suggest a 8.5 hours shift (but still can insert more or less), add the hours in the end and tells me if someone is working more than 5 days/ week so they get the time off in lieu. It would also be an advantage if it shows if the current week is a even ore uneven one(trainees go to school). And the cherry on top is if it could mark public holidays (preferable the ones in Germany). So, I would be very grateful if someone knows where the perfect thing is and could point me in this direction. Well, if it doesn't exist I need to do my own and permanently have to harass the newsgroup. Please excuse my English, but it is 2:15 am and I just came from work. Thanks a lot in advance, Andreas |
#2
|
|||
|
|||
work schedule again
If you've looked all over the web, you may have seen these already,
but ......... http://www.cpearson.com/excel/overtime.htm http://j-walk.com/ss/excel/files/timesht.htm http://www.mvps.org/dmcritchie/excel/datetime.htm HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- On Fri, 26 Sep 2003 13:21:34 +0200, "Andreas Preußer" wrote: Hey there, I'm looking all over the web for a template which suits about 12 employees. They work sometimes split and double shifts (and me 24/7). I thought it automatically inserts the date for each day, suggest a 8.5 hours shift (but still can insert more or less), add the hours in the end and tells me if someone is working more than 5 days/ week so they get the time off in lieu. It would also be an advantage if it shows if the current week is a even ore uneven one(trainees go to school). And the cherry on top is if it could mark public holidays (preferable the ones in Germany). So, I would be very grateful if someone knows where the perfect thing is and could point me in this direction. Well, if it doesn't exist I need to do my own and permanently have to harass the newsgroup. Please excuse my English, but it is 2:15 am and I just came from work. Thanks a lot in advance, Andreas |
#3
|
|||
|
|||
work schedule again
schrieb im Newsbeitrag ... | If you've looked all over the web, you may have seen these already, | but ......... | | http://www.cpearson.com/excel/overtime.htm | http://j-walk.com/ss/excel/files/timesht.htm | http://www.mvps.org/dmcritchie/excel/datetime.htm | | HTH | Paul Yes, i did so. But it is not really what i am looking for. thx, Andreas |
#4
|
|||
|
|||
work schedule again
Hi Andreas,
Sounds like you need someone to write code to do everything you need. There are lots coders on the web, many of whom frequent the Excel newsgroups. Maybe try a few of the more frequent posters. tim wrote in message ... If you've looked all over the web, you may have seen these already, but ......... http://www.cpearson.com/excel/overtime.htm http://j-walk.com/ss/excel/files/timesht.htm http://www.mvps.org/dmcritchie/excel/datetime.htm HTH Paul -------------------------------------------------------------------------- ------------------------------------ Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------- ------------------------------------ On Fri, 26 Sep 2003 13:21:34 +0200, "Andreas Preußer" wrote: Hey there, I'm looking all over the web for a template which suits about 12 employees. They work sometimes split and double shifts (and me 24/7). I thought it automatically inserts the date for each day, suggest a 8.5 hours shift (but still can insert more or less), add the hours in the end and tells me if someone is working more than 5 days/ week so they get the time off in lieu. It would also be an advantage if it shows if the current week is a even ore uneven one(trainees go to school). And the cherry on top is if it could mark public holidays (preferable the ones in Germany). So, I would be very grateful if someone knows where the perfect thing is and could point me in this direction. Well, if it doesn't exist I need to do my own and permanently have to harass the newsgroup. Please excuse my English, but it is 2:15 am and I just came from work. Thanks a lot in advance, Andreas |
Thread Tools | |
Display Modes | |
|
|