I have one text box that contains a value for the "Start Time" and another text box that contains a value for the "End Time."Both of the values are expressed in a format for military time (i.e. 1200, 1300, 1430, etc.).When the "End Time" text box loses focus, I would like the "Elasped Time" (expressed in minutes) to appear in a third text box.Seems easy enough...right?Well the problem I'm having is since the first two numbers in military time are base 24 and the last two numbers are base 60, a standard calculation subtracting the "End Time" from the "Start Time" does not yield an accurate result.
I have a monthly forecast showing expense accounts by cost centre so columns headings look like: Cost Centre, Account Number, Jan, Feb, Mar etc
Using VBA code to automate the process, I need to calculate the total for each month of each account number where the 2 left characters of the cost centre are the same. I have a formula which will calculate this (for one cost centre grouping/account) which looks like this:
I am not sure whether there is a more efficient way than using a formula like that (at the moment this would be used for 12 months on about 6 cost centre groupings with about 500 accounts each - though this would vary). Its not massive, but could be slow to calculate. I don't think the subtotals command is powerful enough, and I haven't used arrays for a long time (especially for what would appear to need a dynamic, mulch-dimensional array).
I am trying to calculate a total cost from an elapsed time. Dependant on how long the time is, this will calculate the total cost. It has to be 3 to every hour. The elapsed time is displayed in label6 in "hh:MM:ss" format and the total cost needs to be displayed in label8.
Im using the express edition of VB.Net to do my project. I have several threads in my program which run fine. However, im stuck at this problem. I have a button in my form, which if I click I will call ThreadA (works fine), If i keep it pressed for more than 2 sec i need to call ThreadB (doesnt work), and if the time is more than 2 min, i need to stop and send a msg to the user. I have tried the timer to calculate the elapsed time, so the tick function would call the thread. BUT this doesnt work... Im not sure what do to.
display a Decimal (or double) to elapsed time [h]:mm:ss (hours:minutes:seconds)using vb.net?
example:
if you were to type "1.34666666666667" into a cell in Excel then choose Custom Format [h]:mm:ss The result is an elapsed time of "32:19:12". Using the OADate function only runs on a 24 hour clock so this does not work for longer durations unfortunately...
Bit stuck on this one, have seen alot about how to do it just cant seem to get it right. I want to have 2 text boxes with times in them.. at the moment i have them on click events then it just runs a Now for the time and fills the boxes from the system time. But then i want the 3rd box to find the elapsed time from the 2 times in the previous boxes but i just cant seem to figure it out
Bit stuck on this one, have seen alot about how to do it just cant seem to get it right.I want to have 2 text boxes with times in them.. at the moment i have them on click events then it just runs a Now for the time and fills the boxes from the system time.But then i want the 3rd box to find the elapsed time from the 2 times in the previous boxes but i just cant seem to figure it out
I have a very simple StopWatch application in Silverlight. I have the following private properties in my MainPage class: _StopPressed (bool), _TimeStart, _Elapsed (string). I also have a "Start" and "Stop" button. The "Start" button calls a method called UpdateTime that constantly updates _ElapsedTime until _StopPressed is true. When I originally wrote it, UpdateTime would block the UI so I couldn't press the Stop button, so I updated my code to use System.Threading.ThreadPool.QueueUserWorkItem with my UpdateTime method so that it updates _Elapsed on a background thread. That works great at updating the value.However, if I try to set the .Text value of my TextBlock from within UpdateTime(), I get an UnauthorizedAccessException that has to do with one thread accessing the data in another thread.What do I need to do to avoid getting this exception and appropriately update the UI without blocking it?
How long it would take to generate all of the numbers between 1 and X randomly. X=1,000,000 took 6 seconds, and for 10,000,000 took over a minute. Does that sound reasonable?
Experiment stopwatch start count = 0 do while count < x select a random number between 1 and X inclusive have i selected this number before? no-add 1 to count yes - loop stopwatch stop display elapsed time
I made the Do Loop UI un-friendly and ran this from the IDE using CTRL-F5. My PC is 1.8Ghz and has 2GB of memory. I am using VB 2008, .Net 3.5 SP1. Looking for work - Zip 65101 [URL]
I'm creating a multi-threaded application (although it is not at the moment) which will be connecting to a large number of sockets. I've noticed when a connection cannot be made the connect timeout is rather large, so I am trying to make my own. Here is what I have come up with...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click CreateSockets(2) AssignSockets(0, "192.168.31.2", 80, False, False) 'shouldn't connect AssignSockets(1, "192.168.1.1", 80, False, False) 'should connect
[code]....
Looking at the timeoutOccured() sub, you can see I'm unsure of how to specify which index to set. Efficiency is important since this will be housing a lot of connections at once. Something else that just came to mind, would .theTimer.Stop reset the tick value on the timer?
I have a listbox with two values, Current account and Deposit account.The current account has an interest rate of 7% and the deposit account 3%.I have 4 other textboxes. The boxes on the right is where the user inputs and the left side holds the value.
Account Type [ ] Listbox >>[Current account] Deposit account Investment Amount [ ] [ ] Interest over a year [ ]
What I want for the Investment Amount is that if the user selects Current account, the amount invested will be automatically calculated with the 7% interest and the same for the deposit, calculation with 3% interest.And the Interest over a year textbox to show how much the interest will be over that year at the rate (whether its 7 or 3%)
how to capture an on/off signal from a relay and count the seconds of elapsed time between the cycles on a com port? Also, which pins on the com port should be used for this?
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
i have a question on how to add two values of placeholder on different forms. in the forms i put a placeholder for "correct answer" and "wrong answer" so one of this placeholder will have a value of integer. how can i add a value on the first form to the other placeholder of the other form.
I have to calculate values of several equations in an application. For example, one these equations could be:
d = a + b*z + c*z (this is what is being displayed to the user, assume that 'a', 'b' and 'c' are provided as textboxes, assume that z is a hardcoded value for now)
Now, the user could enter a=1.5, b= -0.5 and c = -0.6 (or even 'a' could be negative). So, I just tried a sample code for simple values but to no avail...
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Dim val1, val2, val3_calculated, first, second As String first = "8" second = "3" Dim arr(10) As String [Code] .....
Error: But it throws an error saying that I am not using any databind control.
Concerns: First of all, is it necessary to use this "eval" operator in here? Is there any way to keep "-0.5" with the sign in asp.net using vb?
With the application i'm building i have to do some calculating, ive so far not had to do anything like this so i could use some pointers. Here's the simplist of calculation i have to do, if i could get some help pointing me in the right direction i could probabaly figure the rest out.
It would be Box1value * box2value / 144 = box3 But if box 3 returns a value of less than 2.5 it rounds up. The rounding function is very important to subsequent calculations i will have to make.
So the this simple form would work where the user inputs a number into box one and two and the calulation appears in box 3. Attached is a mockup of the form design.
I know about DateDiff and TimeSpan. I am doing a project. I save a date in the registry. Now, I have to test this date against today's date and calculate the differences in minutes, hours, days, months, weeks and years.
I save the date in the registry like this: Application.UserAppDataRegistry.SetValue("Date", [Date])
I then made a sub to calculate the differences: Private Sub Calculate() Try Dim DateGen As Date DateGen = CType([Date], Date) Select Case TimePeriod [Code] .....
As you can see, based on the difference between these dates ( today's date and the registry date ), a sub gets called and the program continues. Unfortunately, the minutes and hours never calls the RandomAlpha sub. How can I calculate the difference in minutes, hours etc.????
I have a button which on click will save the data into the database and after successful entry of data a messagebox will be displayed.Now,all i want to do is I want to calculate the time of how long does it take between clicking the button and displaying the messagebox.
I am making this for a homework assignment and i need to calculate the average for values entered in textbox1 and place them in other textboxes. I dont understand how to do this with numbers all placed in the same spot. here is my code thus far:
Private Sub Label1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label1.Click End Sub
I am trying to calculate the exact amount of time in Years, Months and Days between 2 date values. I'm getting stuck on the day calculation. I've returned the # of months and it's value is 8.77. The .77 needs to be rounded to 8 which should give me the days. I'm not exactly sure what MATH function to use to do this.
I created a software which download files from the web. I also added a progress bar which shows the download progress. Every thing works fine.
Now: - How can I add a label that will calculate the time left for the file to be downloaded and another label that will tell the speed of the download? - Would it also be possible to add a label which calculates the size of the file that is begin downloaded?
Here is what I declared: Imports System.Net Public Class Form1 Dim WithEvents Download As New WebClient Dim WithEvents Download1 As New WebClient Friend WithEvents Label1 As System.Windows.Forms.Label
Here is what I have under the download button: Download.DownloadFileAsync(New Uri("URL" & ComboBox1.Text & ".rar"), Textbox1.Text & "" & ComboBox1.Text & ".rar")
And here is what I have under Download_DownloadProgressChanged: ProgressBar1.Value = e.ProgressPercentage Label1.Text = e.ProgressPercentage & "%" If ProgressBar1.Value = 100 Then MsgBox("Download Completed!", vbInformation, "Info") Label1.Text = "0%"
Not sure exactly where to begin with this one. i have a screenshot that would make this easier to ask, but I can't figure out how to post it here.
[Code]...
How can I apply/combine both of these so that it will figure the datediff for each row (on a datagridview), figure the appropiate case and then update each annual leave row in the database?
[code]If I wanted to get Part Name for multiple PartIDs from OrderDetails, how would I go about doing this? Would I use two DataTables? I'm confused as I cannot see an efficient way to do this. The only thing that I can think of is to create a DataTable with SQL:[code]and then maybe use a For loop to take each PartID, create another DataTable to find the PartName for that and then give this to a variable. There could be up to 10 PartIDs to search through and I don't want to have variables such as PartID1 PartID2 etc. [code]