mon

Hi I am preparing the Project Plan and in which i need arrive at a day when task is suppose to happen. E.g BRD Completed - Mon,20,Aug,18 Submit BRD for BS-Review(cut off is every Friday or Tuesday) Review Date: Every Monday and Thursday I have used following formula H29 = Mon,20,Aug,18...

I have a spreadsheet that calculates the time a surgical case takes on a particular shift (Thanks shg!). I am attempting to create a Pivot table that could analyze how much of the available room time is taken in a particular room or group of rooms during a given time period I inserted a...

hi can any one help please, really stuggling to get this numbering to work, i have a list of wagons days leaving and need to order them with numbers counting, wagon leaving sum needed to auto count according to time leaving like...

Hello, I'm working on a project management spreadsheet and having 1 issue, automating % done. I need the sheet to look at the column A, "WBS", and calculate percentage done based on sub-tasks within that project. For example, 1 = Product Development, 1.1. = Need Development, 1.1.1 = Reviews...

Hi, I need some help and I don't know where to start with this one? I'm trying to build a resource plan, tasks take specific amount of time and I want to add or subtract this time to existing times to calculate the date they would be processed on? My date range would have non working days...

In col A I have a list of dates for any given month. In col B I have the days of the week that correspond to the date in Col A. In col C to F there is other data. My challenge is that I wish to format the cells with a line between each Sunday and Monday of each week in the month. Example...

Is this possible? I have an array of IFs that's matches 1 row and returns a 4 column range, so 4 numbers. I can sum this fine but when I try passing it as the first argument in to sumproduct, I get a value! error. Here's some sample data: <tbody> 1 A B C D E F 2 apple mon 1 2 3 4...

Good evening, On row 2 Starting in column A I have the days of the week (Mon, Tue, Wed, etc) all the way through column Z. I’m wanting to apply a conditional format based on the value in cell A1. For example if I type in Mon. In A1 I want all of the cells in row 2 that are listed as Mon. To be...

Please help! Is there a formula that I can put into cell E5 that calculates... for cells E2:E4 if E=1 and D="" then B*C, and then returns the sum in E5? Cheers! <tbody> A B C D E F 1 person Cost % mon tue wed 2 aa 20000 10% 1 1 1 3 bb 30000 20% 1 1 4 cc 10000 30% 1 5 Cost...

Hello, <tbody> WeekDay Time Wait Time End Point Weekday From To 9117 Menu Commercial - Place an Order <tbody> Mon </tbody> <tbody> 09:13 </tbody> 47 <tbody> Commercial - Invoice Inquiries </tbody> <tbody> Mon </tbody> <tbody> 09:00 </tbody> <tbody> 09:15 </tbody> ...

Hello Board, I was using this formula =0+MID(C2,5,6) to convert this Mon Dec 11, 2017 into this 12/11/2017. It worked up until 2018 came along. If I use it now, it will convert this....Mon Dec 11, 2017 to this, 12/11/2018. please let me know what is wrong.

Good morning all, Is there a formula that can help automatically iterate a date to the next hour, as so? Thanks for your help! <tbody> A 1 Mon 1/8/18 12:00 AM 2 Mon 1/8/18 1:00 AM [=A1,Hour++] 3 Mon 1/8/18 2:00 AM [=A2,Hour++] </tbody>

hi I am currently using this formula to calculate net pay. it only works on the first row cells. When I change to cell range it don't calculate properly. =(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10 Snap of spread sheet...

I'm trying to sort a date column by a range of dates found in a column of another sheet. I feel like my issues is with my weak understanding of populating arrays. Am I declaring and populating the array "Arraystring" correctly? If so why am I not able to autofilter the date column I need to...

I have the following information that I want to use to populate an excel monthly calendar <tbody> stake out Mon, Oct 02, 17 0 Mon, Oct 02, 17 excavate Tue, Oct 03, 17 2 Thu, Oct 05, 17 layout/pour footings Fri, Oct 06, 17 2 Tue, Oct 10, 17 weaping, drain, rock/gravel Wed, Oct 11, 17 1...

Hi, I have an issue. I have some data in Excel which I need to covert. The data is in the format: Mon 12/30/2017 where it needs to be Mon 30/12/2017. I have tried Data>Text To Columns>DMY with no avail - so please do not mention that. Helpful advise welcomed as it's bugging me! Thank you.

OK so I think I'm making this more complicated than it should be... I have a list of data like the below (Table 2) and a separate table with the code opening and closing times which vary by day of the week (Table 1). I'm looking to get a list of unique codes with the totals falling between...

Dear Guys, Hi...... I Need formula to know find the specific date of absent in one cell for an employee... Kindly advice me... Note: A-Absent P-Present WO-Week-off Waiting for your soon reply. I given below my attendance sheet format. Kindly Update...