I tried to use Cdate to subtract two "times", but it didn't work

ex. 2:10 - 1:10 = 1:00

what function can i use.

Here's another way to do times... I was thinking there was an easier way, but can't remember offhand.

Generally you can use CDate(), Format(), DateAdd(), the following code, or a combination of functions.


Private Sub Form_Load()
    Dim hr1 As Integer
    Dim mn1 As Integer
    Dim sc1 As Integer
    Dim hr2 As Integer
    Dim mn2 As Integer
    Dim sc2 As Integer

    hr1 = Format("2:10", "h")
    mn1 = Format("2:10", "n")
    sc1 = Format("2:10", "s")
    
    hr2 = Format("2:15", "h")
    mn2 = Format("2:15", "n")
    sc2 = Format("2:15", "s")
    
    MsgBox ("Hrs: " & hr2 - hr1 & " Minutes: " & mn2 - mn1 & " Seconds: " & sc2 - sc1)
End Sub

As soon as I posted, I found it...


DateDiff("n","2:10","2:15")

Lookup DateDiff in the msdn library for all the options, "n" is minutes, "s" is seconds, "h" is hours.