943,973 Members | Top Members by Rank

Ad:
  • VB.NET Code Snippet
  • Views: 7578
  • VB.NET RSS
0

Calculate Sum of Two Time values

by on Nov 14th, 2008
''' <summary>
''' FUNCTION TO CALCULATE SUM OF TWO TIME VALUES
''' PASS TWO DATE VALUES AS STRING
''' </summary>
Function GetTimeSum(ByVal dt1 As String, ByVal dt2 As String) As String
Dim ReturnStr As String = ""

If dt1 = "" And dt2 <> "" Then
Return dt2
ElseIf dt1 <> "" And dt2 = "" Then
Return dt1
End If

Dim Min1 As Integer = dt1.Substring(dt1.IndexOf(":") + 1) 'MINITUE OF FIRST DATE
Dim Min2 As Integer = dt2.Substring(dt2.IndexOf(":") + 1) 'MINIUTE OF SECOND DATE

Dim Hour1 As Integer = dt1.Substring(0, dt1.IndexOf(":")) 'HOURS OF FIRST DATE
Dim Hour2 As Integer = dt2.Substring(0, dt2.IndexOf(":")) 'HOURS OF SECOND DATE

Dim TotalHour As Integer = Hour1 'TOTAL HOURS
Dim TotalMin As Integer = 0 'TOTAL MINUTES

Dim ExtraMin As Integer = 0

If Min1 + Min2 > 60 Then
ExtraMin = 60 - Min1
TotalHour += 1
TotalMin = Min2 - ExtraMin
Else
TotalMin = Min1 + Min2
End If

TotalHour += Hour2

If TotalHour.ToString.Length = 1 Then
TotalHour = "0" & TotalHour
End If
If TotalMin.ToString.Length = 1 Then
TotalMin = "0" & TotalMin
End If

ReturnStr = TotalHour.ToString & ":" & TotalMin.ToString

Return ReturnStr
End Function
VB.NET Code Snippet (Toggle Plain Text)
  1. Time
  2. sum
  3. Integer
Comments on this Code Snippet
May 6th, 2009
0

Re: Calculate Sum of Two Time values

How do i pass two values from to different text boxes to this function?

thanks for input
Newbie Poster
roby22 is offline Offline
8 posts
since May 2009
Message:
Previous Thread in VB.NET Forum Timeline: Scan Documents From VB .NET application
Next Thread in VB.NET Forum Timeline: Vb.net to Oracle





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC