Dim sDate, eDate, sTime, eTime As String
Dim Date1, Date2 As Long
Dim Elapsed As Long
Dim Seconds, Minutes, Hours, Days As Int
Dim WOHours, TotalHrs As Float
DateTime.DateFormat = "MM/dd/yyyy"
DateTime.TimeFormat = "HH:mm:ss"
sDate = "11/28/2012"
eDate = "11/28/2012"
sTime = "14:27:28"
eTime = "16:53:49"
If sDate <> "" AND eDate <> "" Then
Date1 = DateTime.DateParse(sDate) + DateTime.TimeParse(sTime)
Date2 = DateTime.DateParse(eDate) + DateTime.TimeParse(eTime)
Elapsed = Date2 - Date1
Seconds = Round(Elapsed / 1000)
WOHours = Seconds / 3600
TotalHrs = TotalHrs + WOHours
Msgbox(" Seconds:" & Seconds & " WO hours: " & Round2(WOHours,2) & " Total hrs: " & Round2(TotalHrs,2),"")
End If