schedule

I'm working with Excel Office 365. (windows 10) I've been asked to streamline a scheduling process using Excel. Once the schedule is complete that "sheet" will need to be sent to employees and client. Here's what I would like to do... 1. Create a workbook with 3 "sheets": Requirements...

<tbody> </tbody> I have a production schedule that I need to modified from 24 hours per day / 7 days a week to 12 hours per day / 5 days a week no weekend. I cannot figure out how to count for the weekend. I am able to adjustment the hours on schedule if we are ahead or behind in...

Hi! I have two schedules - a posted schedule, and one pulled from our time keeping system. I would love to set up a formula that will post the following: If the times listed on both schedules match, or are within 6 minutes of each other, the cell will read "on time" If the times listed on the...

Hi, I am trying add up the amount of times someone works between a certain times over the course of a month on a schedule. For example how many time did they start between 5am and 9am so I have put in the below formula. =SUMPRODUCT(--(AND((LEFT(B6:H6,2)>="05"),(LEFT(B6:H6,2)<"09"))))...

I am trying to create a amortization schedule for an auto loan where the monthly payment changes based on the previous payment. I found a template that creates a amortization schedule but the payment is fixed throughout the schedule. My first payment when I first started paying was $360 for 60...

Hi! I'm really hoping someone here can help me. I'm going to try and be as concise about my question as possible, but please ask for clarification if needed. I have a fillable PDF where users are given approx. 60-240 schedule choices (depending on which group they are in) which they rank...

Hello, I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other...

Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you <colgroup><col width="64" style="width: 48pt;" span="5"> <col width="78" style="width: 58pt...

I’m in need of some help speeding up my Excel spreadsheet. I have been working on a solution for weeks, and I don’t know what else to do. About I track hundreds of project schedules that use the same schedule outline template. Each schedule performs at different time frames. I’m currently...

Hi all, I have a simple VBA workbook code to allow my grouped rows to be grouped and ungrouped when a sheet is locked. I have 2 sheets, Estimate & Schedule. It only works on 1 sheet that i name eg: "Estimate". How can i make it work on both sheets or the entire workbook? Option Explicit...

Hello all, new member to the Community looking for help. I was recently given a project at work and it has to do with Excel. I’m supposed to figure out how much product is being shipped and how many are staying behind. I was given a list of Product that has been delivered and a list of the ones...

Hi all, I was given the following formula by one of you guys on here (Thanks so much) It works apart from the fact I would like it to look down the two columns and match the specific text then do the remainder of the formula rather than be assigned specifically to each row ('PMI Schedule...

Hi, looking for some help - I am at a basic level at excel, have to use the formula wizards for vlookups and generally use google to find an answer and use trial and error to find a solution. To this question though, cant find anything, We run a team of engineers that work over several projects...

Hi there, I maintain aworkbook that has a sheet where the staff schedule is laid out in columns asfollows: A = Staffmember name B = MondayStart Time C = MondayEnd Time D = TuesdayStart Time E = TuesdayEnd Time etc., endingwith M/N for Sunday Start/End Times Anothersheet includes relevant...

Hello, First post on here but have used this site countless times as a reference. I am creating a heat chart for staffing purposes to show how many people are on shift for a specific day/time. The first sheet has schedule info (Name, Start Time, End Time, and 1/0 for each day of the week...

Hello everyone, I am working on creating an employee schedule with multiple employes. I have entered a start time and an end time for each shift. There are days where employess will be off and if working they will receive a half hour lunch. I have looked online and was able to find a formula...

Hey all, I am new to the forum I am absolutely stuck and would like to see if I can get some assistance. I have been working on my schedule program for awhile now and actually have a completed schedule but would like to make some much needed tweaks to make it even better. I’d like to add a...

Hello, I have a daily appointment schedule that is going to be shared with 3-4 other people. We all work at the same company but at different locations. The schedule is for a truck washing station for our company trucks. Essentially the different locations are going to send their trucks to...

Hi Please can you assist me, I need to work out a total percentage "Yes" in the below colums. If I use the countif formula it only works on 1 column (B) but it needs to calculate column B + D + F. <tbody> Column A Column B Column C Column D Column E Column F Updated schedule Yes correctly...

Hi there, I'm relatively new to Excel and I have created a Workbook with several tabs holding all our equipment, their service/PAT test dates and conditioned the cells to turn either red/yellow/green dependent on whether or not the date is satisfactory. As there are a large amount of equipment...