calculate

Dear Folks, I am stuck in a situation where I would like to calculate the total processing hours of a request. Of course I have request receive time and request processed time. Both time are in dd/mm/yy HH:mm:ss format. I have tried many combination of formula to calculate total working hours...

Hi All, Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays? =IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2)) Thank you Bryan

Hi, everyone. I found a problem in Excel. Can any better method be used to calculating two GPA (E2 and E7 in the following)? Example: Table A: Table B: Now, I am using following formulas in Table A...

Good Day :) I have to calculate the per day amount for a project and put it in a report showing it on an annual basis. My issue comes if the project starts mid of the month, i need a formula to determine the date from project start to year end and calculate per day rate. Eg: Project Start...

Hi, I'm conducting a performance comparison between various versions of Excel. I'm looking for real world examples of slow or expensive to calculate sheets. If anyone knows of some examples they could share that would be great. Thanks, Mark

Afternoon all, Scoured the forum and can't find anything that meets my needs. I'm looking to create a "library" of sorts that calculates an average score, based on a number of marking definitions. We often look back through previous months and update scores so I was trying to find out if...

Hi! I need a formula or something that will calculate a ship day of the week without using an actual date. For example, my scenario is this: x load is delivering on a Monday. The transit time from origin is 3 days. What day of the week did the load ship? The answer would be a Wednesday (don't...

I have a formula to calculate payment in 30 days, =PMT(cell# with percentage rate /12, cell# wit term, - cell# of amount financed) BUT I can not figure out the formula for a 45 day to payment, can anyone help? THANK YOU

I am trying to calculate the time span between a certain date and todays date EG 12/08/2014 to 17/07/2019 The date 12/08/2014 is generated by a formula Thank you

Hi guys. I am struggling with this one. So far I had this code to test my color changing shapes. I created a small table with Shape name, Value, Target Value It was working whenever I manually typed over the value. But now I have to change the code so the value triggers the macro coming...

Hello everybody. I've been studying some of the solutions found in mrexcel.com about dictionaries. Having applied them "blindly" to my issues with success, I've decided to understand better their dynamic. Suppose I've a table like this: https://imgur.com/h2sfGql How can I build a dictionaries...

Hello All, I am trying to build a template to calculate the selling price of an item given the various costs. Assuming I buy a product for $10.00, I expect to make a 10% profit Margin so technically I would need to sell it for $11.00 So far I can handle it, the issue is that the platform where...

I've got roughly ~10k rows of data that I need to assign an individual rank to (1-4). From this, I need to have some sort of lead sheet (so, 4 additional sheets) for each rank (1-4) that will calculate the decile for each by the the individual 1-4 defined rank. Essentially would have the...

Hi I am using the if function in the calculation of tax . am looking if it is possible to use vlookup index match to calculate the tax amount

Hello, does anyone know of a formula to calculate the median from this frequency table? (assuming the list goes on, way beyond row 10) <colgroup><col><col></colgroup><tbody> number frequencies 0 1240 1 2395 2 5538 3 9837 4 14545 5 16061 6 21340 7 25770 8 22434 9 17497 10...

Hi All, I created a calculator with data validation and then created a formula to calculate qty of t-shirts by color by size using SUMIFS, but when I change the data in the calculator, the data leaves the previous cells calculation, For example, if I have 5 green t's in small, the result is in...

Hi, We use Excel for our timesheet. The formulas work well, except for the PTO (Paid Time Off). We can't get it to add to total hours without adding to regular. Here are the forumulas: Total Hours: =ROUND(IF((OR(B16="",C16="")),0,IF((C16<...

I have start times listed in column A and corresponding stop times in column B I need a macro to calculate all the elapsed time and create a new stop time adding all of the elapsed time together. So if: A1 = 12:00 PM B1 = 1:15 PM A2 = 1:30 PM B2 = 2:15 PM A3 = 10:00 PM B3 = 1:30 AM Total...

I have a mortality table for 100 people, and I'm trying to calculate the expected deaths each year for 20 years. This requires me to calculate the probability of one death and multiply by 1, then calculate the probability of two deaths and multiply by 2, and so on up to 100. The setup of the...

Hi , In Column B I have dates of incidents . How do I calculate how many incidents were in each month? I tried this =COUNTIF((B2:B1000),"<31/01/2019") Which obviously calculates a range but is there a formula I can use that would just calculate each months incidents?