# times

1. ### Excel performance analysis - Software

Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc? I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...
2. ### VLOOKUP look for last cell

Hi all, I have a workbook that has two sheets. Sheet1 and Sheet2. Sheet 1 will have employee names in column "C" The name will appear on sheet 2 in column "C" as well The times I want to lookup are in columns G and H in sheet2 I am using this formula below in column M and N in Sheet1 to find...
3. ### Time calculation run hours per day

I need help to get a calculation of run hours per day for 3 units, based on generator breaker shut/open times. We currently use an integration over time to count the time for the breakers closed, but this gets messed up when the computer is rebooted or updated. I need to calculate the decimal...
4. ### Repeating same range of data

Hello, How can I dos this? I want to repeat a range of data which contains 3 colums and 70 rows 20 times. First colum contains a reference number, same for all 70 rows, second column a vale which doesn't change and third colum the name of 70 different countries. I want this range to repeat again...
5. ### How do I use this to repeat Column n times based on number in table?

I hope this is possible, but I want to be able to repeat column headers n times depending on the table below. I would just put the formula on the far right on the same row, but hoping it would come out like the bottom picture. Thank you if you know how to do this! Example of output:
6. ### Countifs for repeated cell combinations

Hello, I have been trying to figure out a formula that will count how many times a particular part has been in our facility. Parts are identified by part number and serial number so I need to count the combination of the 2. Example: <tbody> <tbody> part_number serial_number Amount of Times...
7. ### I need help with some stock market math

Here's a link to the table I'm working on. https://drive.google.com/open?id=11xxNJBIXnwgfm8E5Q27U5wF8xbMMPeB_ note: I'm expecting either a 61.8% or a 78.6% Fibonacci retracement so I'm using those percentages. I'm trying to calculate the return of a strategy where you short the coming bear...
8. ### Swimming times in hours, minutes and seconds

Hi I need assistance with Swimming times in hours, minutes and seconds. I have a small swim squad and I would like Excel to add the times in minutes and seconds for every 50 metres. Eg for 400 m swim. Example: Tom 47.04 49.03 51.12 54.89 It would also be advantageous to know how to...
9. ### Help me with entering times in Excel

Hi all. I've got some cells where I want to enter times of the day (and be able to do calculations on them so they probably can't be text). I've got the cells formatted as Time and then using Custom and have formatted to hh:mm. So I do that and it shows like that. However. When I type into...
10. ### Runtime error 91 Object Variable or with block variable not set

Some times when I step through or run the code below it works but majority of the time, I will the error message stated in the title. When I make a selection with the combobox and watch the code, there is nothing set in the rEmpIniValue and rEmpIniValue.select turns yellow. But there is a value...
11. ### mode

Trying to use mode on data with negatives times. <colgroup><col span="2"></colgroup><tbody> -0:11 #value ! -0:06 #value ! -0:03 #value ! -0:05 #value ! 0.01 0:08 0.00 0:00 0.00 0:01 The #value is removing the seconds if present formula INT(CJ15*1440)/1440 I'm removing seconds...
12. ### Increment value of cell if another cell changes value

Hello, Is there a way in Macros or VBA to increment the value of a cell by 1 if another cell changes value? Ill give the example: In cells A1 to A56 I have links to another workbook that update every few seconds. I would like to count in Column B -- B1 to B56 -- The changes from each cell...
13. ### Times Numbered

Hello! I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3) the only problem is, i need this to start over every time a new day appears in another column. i hope that's clear and that someone can help.
14. ### MAX(IF and MIN(IF not giving results expected

Hi all, I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this: <h5,c16:c28226,0)))}, and="" it="" works="" great! <h5,c16:c28226,0))) <h5,c16:c28226,0))) <h5,c16:c28226,0)))...
15. ### Is Countifs right you use?

I’m trying to return the number of times a name appears in a range of cells based on the criteria of another cell. In column AT I have names of departments: Safety, Quality, FI, etc. In columns AX:BG I have a bunch of people’s names. On another sheet I’m trying to find how many times a name...
16. ### Finding Difference Between Two 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...
17. ### Creating a Compound Table for a Variable Term

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...
18. ### How to solve a issue with three criterias

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...
19. ### Need to paste multiple rows in Excel multiple times

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.
20. ### Using SMALL with multiple arrays Google Sheets

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...

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...