|
Excel questions OR something else...
Hi,
I'm trying to create a schedule in excel but i want it to be EXTREMELY detailed and functional.
At this point, I have the DAYS on the top row(sunday to saturday) and the names on the left column. What I want to do is to save me time whenever I want to add hours in the schedule.
So for example: I hire someone new and i want to give them hours on monday; well instead of just clicking in the cell and typing it out, I would like to have a drop down menu for the START time and one for the END time. so CLICK: 8 Click: 5. I can even have 2 cell per day if that's the need.
Now I think I can figure this out on my own if I keep trying for a few days but this is where it gets a bit complex; I want to have a column on the right after all the days that is my total. So if I give 8 to 5 shifts to someone for 5 days a week, that should total 45hrs. 9hrs every day.
So I'm not looking for you to do this all for me but maybe point me in the right direction??
And if this isn't possible in excel, what should I use? I'd like to have this on a usb key that I can bring anywhere. I know that all the computers I use at work have excel so this why I want to use it. If it would be easier in access or something, let me know!
|