Hi
I'm new
I was wondering if there is a template or example I could get from the
net for a excel project I am using.
My wife has 7 operators that work various shifts thru 7 days and 24
hours.
The shifts are constantly being changed. And being juggled around.
I was thinking if I could make a program where whe just has to click
and drag along 9 hundred to 16 hundred hours and that shift was aloted
to a specific person and the progam also added the total hours worked
for 2 weeks.
I was playing around and made a program that added the peoples hours
together but I have to input all the hours in a 24 hour format each day
with a in and out time.
My wife sometimes works for hours of days on a schedule onlyu to find
it does not work so she has to make a new one.
I thought tonite that there is likely a program out there already.
I just wanted to see a program so I could get some ideas on how to do
it.
Thank you--
frankiee
------------------------------------------------------------------------
frankiee's Profile: www.excelforum.com/member.php...oamp;userid=32331
View this thread: www.excelforum.com/showthread...hreadid=520888There is really nothing in excel that makes it suitable for tasks like this,
however it can be programmed
blog.jausovec.net/index.php?o...d=165amp;blogId=1
look at work schedule, haven't tested it myself
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
quot;frankieequot; gt; wrote in
message ...
gt;
gt; Hi
gt; I'm new
gt; I was wondering if there is a template or example I could get from the
gt; net for a excel project I am using.
gt; My wife has 7 operators that work various shifts thru 7 days and 24
gt; hours.
gt; The shifts are constantly being changed. And being juggled around.
gt; I was thinking if I could make a program where whe just has to click
gt; and drag along 9 hundred to 16 hundred hours and that shift was aloted
gt; to a specific person and the progam also added the total hours worked
gt; for 2 weeks.
gt; I was playing around and made a program that added the peoples hours
gt; together but I have to input all the hours in a 24 hour format each day
gt; with a in and out time.
gt; My wife sometimes works for hours of days on a schedule onlyu to find
gt; it does not work so she has to make a new one.
gt; I thought tonite that there is likely a program out there already.
gt; I just wanted to see a program so I could get some ideas on how to do
gt; it.
gt; Thank you
gt;
gt;
gt; --
gt; frankiee
gt; ------------------------------------------------------------------------
gt; frankiee's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32331
gt; View this thread: www.excelforum.com/showthread...hreadid=520888
gt;
- May 27 Tue 2008 20:43
Program for assigning work shift hours
close
全站熱搜
留言列表
發表留言