• Home
 · 
• Miscellaneous
 · 
• Get the time diffrences between two different time variable (include date). Result will be in diffe

Get the time diffrences between two different time variable (include date). Result will be in diffe

Get the time diffrences between two different time variable (include date). Result will be in difference in days, hours, minutes, dan seconds

Rate Get the time diffrences between two different time variable (include date). Result will be in diffe

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

                    ByRef d As Long, ByRef h As Long, ByRef m As Long, ByRef s As Long)

'get time different in second
    s = DateDiff("s", DTime1, DTime2)

'h is different in hours
    h = Int(s / 3600)
'm is different in minutes
    m = Int((s Mod 3600) / 60)
's is different in seconds
    s = s Mod 60
        
    If h >= 24 Then
'd is different in days
        d = Int(h / 24)
        h = h Mod 24
    End If
    
    
End Sub