times

Hello, I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD. I...

Hi! This is NOT an compound interest question. I need to create a compound formula or table to reach a desired answer. EXAMPLE: So if I need to decrease 50 by 20%, 3 times (variable) ------------------------ 1) 50 x .8 = 40 2) 40 x .8 = 32 3) 32 x .8 = 25.6 ------------------------ Answer...

Hi, I would like some input/pointers on how to solve this, I'm not sure where to begin... I want to write Active, Not active or Ignore in column E based on three criteria. As you can see in the table, a person can occur 2-3 times, even 6 times in my orginal data. Data is sorted on column A. If...

I am looking for a macro perhaps. I have 3 rows of data Columns C to G I want to paste multiple times. Perhaps thousands of times. Is there a way I can cope C1:G3 and then paste it a number of times? I would like in some cases this to be 300 times, and in other cases 1500 times.

Hello there, I'm tracking times in a similar way to this: <tbody> Sheet 1 C D 2 1:00:01 0:59:59 3 1:00:02 1:00:02 4 1:00:02 1:00:02 5 1:00:02 1:00:02 6 1:00:02 1:00:02 7 1:00:02 0:50:50 </tbody> I will have this for exactly 11 tabs, and my goal is to display the 5 (or 10) lowest...

I have to compare two data sets each with 4 Lac plus records. Using Vlookup and Countif takes at least 1 hour and hangs most of the times. Is there any macro or other solution to accelerate the results.

Hi, I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows: <tbody> Date Swimmer A Swimmer B Swimmer C 1/1/2018 01:53.55 01:50.51 6/5/2018 01:34.22 01:45.12 7/9/2018 01:30.10 01:35.12 </tbody> I know times must be...

Hi, I need help with a countif formula. I have one column of data with 458 rows; 4 options and want to count how many times each option shows up in the row. Column A: Option 1 Option 2 Option 3 Option 4 Option 1 Option 2 Option 3 Option 4

H All, I’ve broken my brain on excel and need assistance….. I’ve built a doc to help me calculate the number of staff working by 15 minute interval per day of the week. I have around 50 staff but they all work different days & hours in the day. I seem to be having issues at certain times of...

The below code will allow me to type the number of times to copy a sheet. Dim I As Long Dim xNumber As Integer Dim xName As String Dim xActiveSheet As Worksheet On Error Resume Next Application.ScreenUpdating = False Set xActiveSheet = ActiveSheet xNumber =...

Is there a way to use the Countif function (or any function) to look up a range of criteria? Example: If i had a range of numbers (with repeating values), I would want to know How many times a range of numbers appear. Right now I use =COUNTIF(A1:A100, "20"), if i wanted to see how many times...

Hi, Can someone help me with the vba for the following- I have 2 tables in different spreadsheets, which have a common field -policy no. The main table is in spreadsheet 1 and the other in spreadsheet 2. What is required is to find the number of times a policy no repeats itself in the second...

Hello, I've been searching with no success. I have 300 rows of data and I'd like to insert 7 new rows between each data point, copy that data point down those new rows, then move to the next data point. This will be done 300 times until I have 2,400 rows of each data point copied 8 times. Any...

I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT. I thought the following would workSet ptField = ptPivotTableList.PivotFields("Proper Name")but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable...

For example here is the expression i got...

List of dates in a column, some have times, some do not. I think the ones that do not are due to the time being 00:00? I want to use a SUMIF looking at that column, but looking only at the dates. Is this possible? At the moment the user uses text to columns to split out the time into the...

All, I have a VERY large document that I have to calculate margins in. With so many lines I created a Macro to assist (ctrl+w) by doing a goal seek function. I need one specific margin to make the product viable. This works much better but it's annoying that you can't just drag down...

I have a list say: A,B,C,D,F (IN COLUMN A) I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2) Example. User selected A Repeat 3 List 2 times...

Hi All, Thanks in advance. i have the below sheet <tbody> S.No. Number Description 1 5 2 3 3 8 Na 4 1 5 7 Na 6 9 Na 7 6 Na 8 4 9 1 10 7 Na 11 6 Na 12 2 13 7 Na 14 8 Na 15 4 16 3 Na </tbody> Now i want the result in fourth column (It will check the...

Hi all, I'm trying to build a new tool that takes a 26 hour manual process and automates it, which should run overnight for 10-16 hours. The trouble is working around Excel crashing or halting unexpectedly. I'm testing what I have now and in the last 20 minutes it's crashed or halted three...