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