calculating

Hi guys, I have this spreadsheet. I need to be able to work out how many days holiday each candidate has accrued based on todays date. For example. Based on the amount of days worked per week and how long the contract is for, CAN-10367 will get 30 days holiday for the duration of his...

Hi, I was working on a workbook and all of a sudden it began to run slow, "Calculating 4 processors" for a long time. I've tried deleting all the cells to the right and below but it's still the same. I have other workbooks with the same type of sheets/formatting on it but they are fine. The...

Hi Guys n Girls I am making and Auto Calculating Roster that everything works great EXCEPT totaling the hours worked. What I have is a start and finish time and that returns the hours for that shift, it works on the first 2 entries BUT when I add another day the total goes from 18:30 to 2:3...

=IF(TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n")="0hrs 0min","",TEXT(SUMIF($A$21:$A$27,A31,B21:AF21)/60/24,"[h]\h\r\s m\m\i\n")) Hi, Please help me with above formula, Why it is calculating only B21 values ınstead total of B21:AF21 values? Many Thanks

Hello all, I am new to the forum and in need of some expert help with formulas. I can typically figure out a formula or find what I need by searching online. However, I am trying to do a very complex calculation and am running into issues or not finding the answer online. I know how to do the...

Hi, I am trying to combine the functions IF(), AND(), and LEFT() in a formula, however excel keeps saying #VALUE ! or #NAME ? instead of calculating the formula. This is the formula I typed, please help me find out what the problem with it is. Thank you in advance...

Help? I have created a mileage chart for site to site distances. The sites are listed horizontally and vertically. The bottom half is the distances between sites, the top half is for the cost. It's this that I am trying to calculate. B2 = distance 1 = 100 B3 = distance 2 = 150 B4 = distance 3...

Hello All, Im running into an issue where my IF() statement is incorrectly calculating the formula. For context here is the formula: =IF(SUM(O38:O54)='4 Sources & Uses of Funds'!K48,"OK","CHECK") As mutually exclusive formulas, SUM(O38:O54) absolutely equals ''4 Sources & Uses of...

Hi. I have a spreadsheet that has times such as: 11:59 PM 11:58 PM 11:58 PM 11:56 PM 11:55 PM 11:55 PM 11:55 PM And so on. I'm trying to calculate the total hours in the column but not count the duplicates. I need them so I can't get rid of them but is it a matter of copying the times...

Hi all! I set up a formula similar to this: =SUMIFS($A:$A,$B:$B,">="&D1,$B:$B,"<="&EOMONTH(D1,0)) to calculate projected costs for current/future months. However, in the main set of data there HAS to be a problem because it will not calculate the last day of the month for any month. Any idea...

Hello Everyone, First time posting here, but I use these forums a lot for answering questions, however, I could not find an answer to my current question. There are several similar questions out there, but none that seem to align with what I'm trying to do. So I have a spreadsheet where I am...

Dear Wise members of the forum. Below is a piece of VBA that is working great. I would, however, like to modify it so that it would, after "x" seconds run the Macro one more time. I have put what I would like to happen in bold below. Any help would be very much appreciated!!! KH Private Sub...

I am trying to write a formula to have a cell enter a zero if a cell it is calculating from has an error and if not sum two cells and multiply by something else. Tried using =IF(ISERR(D11),"0","=((D11+D12)*11.5)") but it just puts my formula in the cell and #value ! if not. This is for a...

Hello All new to this and wondering if someone could assist me? I have the below formula in a spreadsheet with a view to calculating a month value from a year and week # the formula below is linked to a parameters tab and I am nowhere near savvy enough to figure this error out. my main...

Hi I have a nested IF string that is not calculating, any help would be greatly appreciated. =IF((AND(B5=AE12,AE13,AE18,AE19,AE25,AE26,E8>=2.251,E8<=2.55)),12,0)

Hello, I am trying to make an Excel sheet that will calculate how many items I can make from my components inventory. For instance, say I need 1 of each: Part A, B & C to make Item 1. I have the below inventory. I want to know what formula or setup I can use to have excel calculate how many...

Hi, I have a spreadsheet that is currently 7800 rows and goes to column BK. A few months back I noticed that everytime I change anything, for instance use a filter at the top of one of the columns, there is a 20 to 30 second delay which also sort of locks up my spreadsheet and at the very bottom...

Hi, I've created a userform where people capture information and have to time the process for the work that they are doing. The information is then transferred to the worksheet and the data moves down the next row. using the following code: Range("A10:V10").SelectRows(10).Insert...

hi, im looking for a way to sort some data exported from an old stock recording software. the system outputs the data as a .csv file but each item bought is grouped into a particular heading, a line is only generated if money is spent under that particular heading. i cannot make the software...

Okay so I have three things I need help with. 1.) I have excel 2007 and when I recorded the macro yesterday it worked just fine, but today it's coming up with the box to update values. The macro is set to open up the vendor assignment sheet and do a vlookup against the clerk and then return the...