seconds

Hi I've built a spreadsheet where I've got a list of say 200,000 Customer Reference Numbers and I setup a loop like For i = 1 to 200000 Range("CustomerID") = Range("ListofCustomers").cells(i) Call ProcessCustomer Next i ProcessCustomer is the macro that does all the hardwork for the...

hi, using the following to prompt the msgbox:- Sub gototots()Range("AI4").Select Application.Goto Reference:="R999C34" ActiveWindow.SmallScroll Down:=-12 Range("AI983").Select If MsgBox("Enter Yes to goto A174?", vbYesNo) = vbYes Then Application.Goto Reference:="R117C1"...

This code belove will take random cells text to Label1.Caption in Form Now i want Lebel1.Caption will appear Cells(1,4) 5 seconds then cells(2,4) 5 seconds then cells(3,4) 5 seconds .... to the end row. Please help me to do that, thanks in advance./. Private Sub Userform_Initialize()<code...

HI, I have had a look round the site and couldnt see an answer on this what is probably a simple question. I have a table of data lets say 5 columns by 5 rows as a named range called data. I want to create a chart where the values loop through each column with a pause of lets say 5 seconds...

Is there a function, add-in, or easy way to format time values so that the units displayed vary with the magnitude of the value? What I mean is that the function will convert the value to the units that will be >1 but less that "1" of the next higher units. If the value is less than one...

I have a portal that needs to be opened 600 times a week and I've made some small progress in optimising it, as it takes roughly 20 seconds to open. This is currently down to about 14 seconds on our regular machines but I'd like to get this under 10 seconds if possible. I've identified an area...

Hello, I have a problem finding function to do the following. (I've forgot the mathematic term for this type of calculation..) Let's say for example that I have 3 robots. Two of those 3 robots produce 1 product in every 10 seconds. Last robot has some major issues, and it takes 20 seconds to...

Hi I have a project with about 240,000 rows of data and 23 columns. There are two columns that I need to compare dates to that are; Date Logged and Date Resolved. The date I compare them to are usually the first of each month from 2017 to present day. I need to track whether or not that case was...

Hi, Curious about fastest way to clear data from a range, I created following and resulting output: Sub testrun() Dim x As Long For x = 1 To 3 testtime x Next x Debug.Print "" End Sub Sub testtime(ByRef testvar As Long) Dim st As Double Dim rng As...

I have 40 queries. When I "Refresh All" I often encounter "the web.page function didn't finish within timeout of 100 seconds." I find, once it craps out, it cannot recover and waiting 100 seconds is too long. Each query normally takes 2-3 seconds, so I can tell quickly that it's failing. Is...

Hello everyone,This is probably quite a simple request however I am having a lot of trouble with it.I would like to write to a cell the previous cells time value + 10 seconds. I have tried several approaches after a lot of googling, however below is what I started with and what I would like to...

A userform is loaded when a certain condition is met. When the same condition is met again, an instance of the same userform is loaded. What I need, is to add a timer after loading every userform to unload automatically after x seconds, so after x seconds this specific instance is unloaded...

Hi Comunity, I am using formula "Range("F6").FormulaR1C1 = "" " as part of a vba macro to clear values from a cell which is working perfectly. But i was curious if there is a way to delay the clearing to say maybe 15 seconds after the macro has ran? Any guidance?

I'm trying to enter a duration in years, days, hours, minutes and seconds then apply a percentage and display the results as NN years NN days NN hours NN minutes NN seconds. I've applied the custom time format yy "years" d "days" h "hours" m "minutes" s "seconds" For now I'm not applying...

I'm in Excel 2013 (on Windows 7 and Windows 10). I use the following Macro by tapping Ctrl+Shift+T to get H:mm:ss in any cell that is formatted in that same way. Sub Time_Stamp() ' Keyboard Shortcut: Ctrl+Shift+T ActiveCell.Value = Time() Selection.NumberFormat = "h:mm:ss" End Sub This has...

Hi I entered time like this 1:30:44 am but excel only shows 1:30 am. Why is that and how can I fix that? thank you so much.

I'm working on a tabular model where there's waiting times in seconds. I've calculated a measure that displays the average waiting time in seconds (10 sec = 10) but how can I show it in (hours) minutes and seconds? The normal number formatting doesn't seem to work ( Normal time formatting...

Hi There, Im tying to have a live timer on my Excel sheet count in seconds between the time of 0730 and 1630. Then reset at 0730 the next and start counting the seconds again. I see many posts on how to do it with a start, stop button but cannot figure out a way o make it start stop and reset...

Hello everybody. I've a value in a cell in hour format: 00:05:37 I need to transform it in seconds: 337 How can I manage the matter? Thank's.

Hello, i have the following code which runs ( slowly) to pull two reports from an SQL internet database, just seems to run slowly, have had timer on the last few days and it takes between 294 seconds and 684 seconds to complete. my problem is that when i use debug step through it only takes...