work schedule again

[Andreas Preußer]

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

 

[pfsardella]

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

 

[Andreas Preußer]

| 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

 

[Tim Otero]

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