scheduling

hey guys i have this scheduling sheet which i need to automate. specifically, in sheet1, my HR planner inputs the dates which each employee is working, over 5 days. in sheet 2, i need to have formula driven range A2:J10 row1 (the date forecast), updates in tandem with the current date. as the...

I am in need of some assistance in tweaking formulas to get the desired results. The situation may be impossible, but I need to ask to satisfy my curiosity. I will try to include the spreadsheet and describe as best as possible...as always thank you for help in advance! I have a file that...

Thanks for reading this I have x amount of tasks in a project over a specific time frame The allocated time for each task can vary i.e. they have a start and end date for each specific task I need to be able to change the amount of time (both start and end dates) allocated if the project is...

I'm doing a shift bid at work, and I need a formula that will count weekly hours per shift. I'm sure this is easy, but I've tried and I'm messing it up. Thanks for the help!

I'm working on a scheduling tool and I need to run a variety of time calculations. It's hard to explain all the nitty gritty details, but at a high level I'm doing a lot of back and forth conversion between decimals and time. I'm wondering what your thoughts are...do you try to do your math...

Hi All, I have had a look and can't see that this has been answered before so hopefully someone can help. I have written a Macro and it's working great. I now need to schedule it to run at 12:00, 14:00 and 16:00 each working day, automatically. I will need the macro to open the file, run the...

I am using Excel 2011 (for Mac). I'm in the process of creating a scheduling template. I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional formatting (highlighting specific colours based on specific...

I have in mind to do a sort of “backwards scheduling”. I know when I have to have something ready, see below: Cell A1 shows the date/time in a specific format: ddd dd mmm yyyy hh:mm Cell B1 shows the work duration to have the job done. This could be formatted as decimal. The working hours...

Good Day all. Since schools is about to start, I thought that I should create a spreadsheet in order to schedule my teachers in the various yard duties throughout the day. What I would like to accomplish is schedule about 25 teachers to cover yard duties. The various duties are as follows: Bus...

Good Afternoon! I have an excel question that has been driving my CrAzY! I can't figure this out, and am not sure if Macros is the best solution? What I need to do is this: - I have created a simple schedule (see copy below) where I can select appointment start times and appt. types from a...

Hi i am trying to set up an accurate schedule for a project to get a projected finish date with the following information. I am using Excel 2003 with XP Say 3 guys that work a 7-5 day (10 hours) are working on something that should take them a combined 43.7 hours leaving them with 13.7 hours to...

Hello, I am needing some help calculating the number of working days between two dates, with the number of working days per week being variable. Not sure Excel has a built in function for this? I have checkout out weekday, workday.intl, and networkingdays, but they do not offer exactly what I...

Hi folks. I'm investigating the possibilities of extending a spreadsheet I've been working on to manage data in a school. I've already completed the first stage of the process, creating the management system on a spreadsheet, but ideally I'd like to generate weekly reports of recent data from...

I had an account on here, but not sure what happened to it so here's to a new one! My issue is as follows: I need to create a formula, process, or otherwise that allows me to take two columns of dates (say G1:G100 and H1:H100) and take whichever is smaller of the two (easy enough right...

I'm a novice excel user. I’d like to be able to use Excel to schedule future random date(s) based on an start date. The generated target date must be meet the following criteria: - should be within 120 days from the start date - fall on a different day of the week (excluding Sundays) from the...

Hello! I have a question about creating a formula that will tell me--based on two different schedules, including different scheduled hours and different scheduled days--how much overlap time there is between two different work schedules per week. Here is the example: I work from 7:00 - 16:00...

Hi folks, I have a question but don't know how to go start about it? I am looking to build a excel to schedule 5 employees, were they rotate thru ON-CALL, Night shift and regular shift. for ON-CALL(one week period): it start 5:00pm -11:00pm Mon - Fri and all day Sat and all day Sun until...

Hello, I have a sheet that is a schedule. It looks like this... Column A Column B 2/20/2009 12:00 PM 1:00 PM Dave 2:00 PM Jonathan 3:00 PM Steve 2/21/2009 1:00 PM James 2:00 PM Sally 3:00 PM Tyler 4:00 PM 5:00 PM John 6:00 PM...