A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

work schedule again



 
 
Thread Tools Display Modes
  #1  
Old September 26th, 2003, 12:21 PM
Andreas Preußer
external usenet poster
 
Posts: n/a
Default 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  
Old September 27th, 2003, 02:26 AM
external usenet poster
 
Posts: n/a
Default 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  
Old September 29th, 2003, 12:28 AM
Andreas Preußer
external usenet poster
 
Posts: n/a
Default 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  
Old September 30th, 2003, 07:27 PM
Tim Otero
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.