seconds

Hi, i am looking some advice to make a script in VBA. I need to get some values summed in time frames that range from 5 seconds to 60 seconds from cells that are updating all the time with 10 to 50 updates per second. Lets say that in 5 seconds I get the values 1 2 3 4 5 1 2 1 2 1 2. I would...

I have an Excel file with 3 tabs that are all pulling info through queries which rotate every 40 seconds. The VBA I have for it works great. After rotating through the tabs I need the queries to refresh via VBA. However, since a macro is being ran, the queries wont refresh until I manually stop...

Hi, TEXT(A1,"hh:mm:ss##:##:00") is not working. How can I format the time as it will show seconds always "00"? I don't want to use any floor or round function because the problem I face is already because of precision overflow. So I want to take a shortcut with text formatting. Eg: 01:00:01 =>...

Hi all, Scenario: a vb.net Program is currently reading some informations from a workbook open in the Application. This may take some seconds. Is it now possible to detect in vba that this currently happens. Thanks Peter

I have a big Excel file over 20 Megabytes. I also have macros, formulas, activeX controls, shapes etc. in pretty well on all 15 worksheets. On one of my worksheets, If I want to hide only one row, it takes 10 to 15 seconds to hide and I can't figure out why. What could be the possible causes??

Hi, I've got the following code to randomize through userforms, however I would like it to loop through on a random time frame from 5 minutes to 15 minutes and show for 5 seconds then close. So just say I click the button to start the macro, it shows a random userform for 5 seconds then...

Hi, Thank you in advance for your support! I basically have 800 rows of data that has links to different websites. What I'm looking for is some VBA code that would allow me to either fetch a screenshot of each of the website or maybe open the website for 3 seconds in a browser window so that I...

I have a cell formatted as hh:mm:ss.000 In the next cell I want to use the TIME function to increase the cell by a set number of seconds and milliseconds. Example 00:00:01.288 in cell A1 Add 00:00:02.500 to the entry in cell A1 and display it in cell B1 I can only seem to get it work with...

Hey! I'm in a bit of a pickle. So basically, I've got over 50,000 lines of columns that I have to convert to charts. And to test it out, I used a pivot table and chart. Everything works fine, but it doesn't detect seconds. So, what I did was: In raw data convert the text to columns as DATE...

I have sheet of times in time format, lets say in seconds, like following.. A1=100 seconds A2=200 seconds A3=300 seconds in B column, I have a divide calculation that converts seconds to wanted time format (ex.hours), =A1/3600, so values are B1=0,027.. B2=0,055.. etc. I also have total row...

I would like a looped code that waits 2 seconds then refreshes the links e.g calculate then waits 2 seconds then refreshes - basically a loop

Background: I have a Sub that uses the "Call" function to run multiple subs within one Sub (see Code #1 below). Option Explicit Sub MIUL_Run_All() Dim StartTime As Double Dim SecondsElapsed As String 'Remember time when macro starts StartTime = Timer Call OptimizeCode_Begin Call...

Hello Everyone, I would appreciate if I can get some help. Please see the attached data sheet. From this sheet, all the data is in seconds and miliseconds. 1. Is there a way to find min, max average values for a given date? For example, for 08-22 find min,max and average transaction times...

I have a column (D) where the user will be required to enter in minutes and seconds into cells (D5-D44). (I only want to work with minutes and seconds, no hours). All cells under this column are custom formatted to "00\:00", which auto-converts numbers typed in to minutes and seconds; For...

I get errors cannot run or check security settings. Private Seconds As Integer Private Sub Workbook_Open() Seconds = 10 ' 5 minutes. Adjust as you wish ScheduleSaving End Sub Sub ScheduleSaving() Application.OnTime Now + Seconds / 24 / 3600, "ThisWorkbook.SaveMyWorkbook", Now...

I have a spreadsheet with numerous macros that seems to be doing two saves when I click to save the file to a shared drive .... G: drive at my workplace. On clicking to save to the shared drive (G: drive), I get the usual swirling hourglass for about 6 to 10 seconds ... this is what I have...

Good day Will others be able to ratify this observation? I've been writing Excel based software for years and have ignored speed of computations (brushed it under the carpet) until recently when even the 2 or 3 seconds the algorithms took seemed too long. I've discovered that if I set the...

I need a formula to convert hours minutes & seconds into total minutes. h m s total minutes Example: 3:04:27 would display 184.27

Is anyone else experiencing dramatically slower loading speeds on the forums since the update yesterday? It is taking a significantly longer time (upwards of 20-30 seconds) for any page to refresh or for a reply to post.

Hey Everyone, I need to show a chart that displays between 0 & 120 Seconds (including milliseconds) for Server Loading times tested daily and, then average out the worst servers based upon the daily values entered. In example; 06/15/2017 - 4.02 Seconds 06/16/2017 - 22.92 Seconds 06/17/2017...