How to add seconds to a time field

1 post / 0 new
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57
How to add seconds to a time field

I had a member that wanted a one line solution on how to add seconds to a time field that was in character format. This is what I came up with. I also made it into a custom function if anyone else needs this functionality.

Option Explicit

Sub Main
    Dim strTime As String
    strTime = "11:59:24"
    MsgBox addSeconds(strTime, "65")
End Sub

Function addSeconds(sTime As String, sIncrement As String) As String
    If Not IsDate(sTime) Then
        addSeconds = "Error"
    Else
        addSeconds = TimeSerial(Hour(sTime), Minute(sTime), Second(sTime) + CInt(sIncrement))     
    End If
End Function