calculations

Hello, I am trying to keep track off time off for employees and I need the calculations on my spreadsheet to calculate only up to 59 and then once 60 is hit, I need it to calculate to 1 hour. My current spreadsheet is calculating up to 99 before hitting the 1hour. I hope this makes sense...

Hello, I've been through a number of different forums and found similar questions but I haven't been able to find a solution that I can replicate. I have inserted a formula to calculate the difference between two values. If the difference is greater than 5% then it returns a value "Reprice"...

So here's my problem, I need to send out a file that requires iterative calc's to be enabled in order to work properly, however its going to a large number of people that may or may not have the knowledge base to adjust the settings. Is there a way to "pin" my iteration settings to the file so...

I am trying to compare old system data to new system data so I made a pivot table. I am trying to subtract each 2 column subset, meaning I have the row as each department number, then I have 26 periods as columns. Each of those periods has two columns "new" "old", this is what I want to...

Dear excel-vba user, For many years I’m using Excel and in case a certain action has to be repeated many times I’m using the macro recorder in which a vba code is generated. Then I insert a form-control from the develop-menu and with the right-mouse button I assign it to the recorded macro...

Hi Everyone, I am calculating a date time timestamp but come up with an answer of ######### due to it being a negative d:h:m example: 7/1/2015 1:30 PM - 7/1/2015 1:27 PM = ######## What I would like to see for an answer is the actual negative number in the d:h:m format (i.e. - 0:0:03)...

<tbody> <tbody> A B C D E F G 1 Company Qtr4 March Qtr4 April Qtr4 May Subtotal Impact Type 2 Co. A $32,083 $32,083 $32,083 $160,145 Savings 3 Co. X $32,083 $32,083 $64,166 Lost Opportunity 4 5 Total savings $224,331 6...

First I have dealt with the .exd issue, but since the update my spreadsheet is acting strange. Background: This spreadsheet started as a 2003 workbook with no macros or vba. It had some 35 - 40 spreadsheet used as user interfaces or calculation tables. As the options were expanded it got...

I'm fairly new to powerpivot. I have many Columns in my pivot table. One of the columns is showing 2013 sales by account. the next column is showing 2014 sales by account. For both of these columns i used the "options" tab and went to the "show values as" calculation area and chose "% of grand...

Hello gents, I'm an IT project coordinator and I'm in need of a custom Excel macro. The self-help videos on YouTube and articles on Google aren't cutting it. I have not worked with VBA before, but I need to create this as a macro because the sheet is dynamic. The current sheet captures, once...

Just looking for opinions... Would an HLookup or a SumIf array be faster?? Thanks!!

I have a spreadsheet with columns labeled with Dept #, position titles, headcount and number of terms and the turnover % for a specific period of time. When I slice the data by depts, my turnover % is not accurate because my only options from the pivot table are to sum, average, min, max or...

Hi, I'm trying to use a formula to select the correct calculation based on the criteria of two different cells. For example; <tbody> <tbody> A B C D 1 29 EXCEED EXCEED 2 27 EXCEED YES 3 22 YES YES 4 21 YES NO </tbody> </tbody> Where B1 and C1 = Exceed, in D1 calculate...

I have a computationally expensive cell formula that queries an online database. I'd like to have calculations set to automatic, except for the cells with my expensive formula, and write a macro that switches calculations on for those specific cells then switches them back off. I haven't been...

Hello, everybody. I would like to ask for your help with the calculations of the long-term averages. Let's sart with a dscription of my situation.. The data of the long-term (48 years) hydrological measurement data I currently work with consists of the monthly discharge data (every 12 months...

I'm wanting to get a count of values. The values are in text form with alpha and numerical, example: AL1, FF2. I looked at SUMIF and SUMPRODUCT to potentially accomplish this. I'm wondering the best course of action to get a total. Here's what I'm looking to do... I have a list of reports...

I have a data table with many records each including an event date. I then use queries to extract and sort data that meets certain criteria. My question is how can I calculate the interval between the dates in successive records. What I need is to show the number of days since the previous...

All, I need severe help with completing this issue. I am trying to do a weird calculation that should work but I keep getting a circular referece error and I do not know why. For example I have several columns from a - p and they contain data regarding testing. the first 5 columns require...

I have used a custom format so that I can enter a time as 115808 and have it show up as 11:58:08. Unfortunately, now i need to do calculations and the calculations are not correct b/c it is not recognizing this as a time. All of the "solutions" I've found for this don't include the seconds or...

Hello, I have a spreadsheet that tracks type of time worked in .5 hour increments with a dropdown menu that has items from multiple categories. The people using the timesheet would select what type of work they did that half hour and it totals a full day of work. BUT I need to try to create...