Dim s As Long Dim x As Integer Dim y As Integer Dim c As String a = "1:32:45" b = "1:45:52" s = Abs(DateDiff("s", TimeValue(a), TimeValue(b))) x = s - Int(s / 60) * 60 s = Int(s / 60) y = s - Int(s / 60) * 60 s = Int(s / 60) c = Str(s) & ":" & Str(y) & ":" & Str(x) Print c
Dim x As Integer
Dim y As Integer
Dim c As String
a = "1:32:45"
b = "1:45:52"
s = Abs(DateDiff("s", TimeValue(a), TimeValue(b)))
x = s - Int(s / 60) * 60
s = Int(s / 60)
y = s - Int(s / 60) * 60
s = Int(s / 60)
c = Str(s) & ":" & Str(y) & ":" & Str(x)
Print c