| | |
Calculate Sum of Two Time values
Please support our VB.NET advertiser: Intel Parallel Studio Home
''' <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
''' 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
Time sum Integer
Similar Threads
- Calculate the sum of digits (MS SQL)
- Trouble with loops - Calculate sum of even and odd integers (C++)
- Assistance needed to calculate the sum of specific elements in an array! (Java)
- Get sum of values in a loop? (PHP)
- recursion - how to calculate sum? (C++)
| Thread Tools | Search this Thread |
Tag cloud for VB.NET
.net .net2008 2008 access add advanced application array basic beginner browser button buttons center class click client code combo convert cpu cuesent data database datagrid datagridview datetimepicker design designer dissertation dissertations dissertationtopic eclipse employees excel exists forms function html images lib listview map mobile module msaccess mysql net number open page pan pdf picturebox picturebox2 port position print printing printpreview problem refresh regex reuse richtextbox right-to-left save search serial settings socket sorting sqldatbase sqlserver storedprocedure studio textbox timer timespan transparency txttoxmlconverter usercontol vb vb.net vb2008 vba vbnet vista visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winsock wpf wrapingcode xml year



