Time > 5PM

I got the DateDiff to work. Now my question is how would I have it figure out this

If EndTime > than 5:00PM Then
EndTime = EndTime * 1.5
End If

Can someplease help me out. I never worked with time before so I completely lost at what I'm doing.

Thanks

Ken Devorak

Hi, Ken.

Code:

---

Dim EndTime As Date
Dim MyTime As Date

EndTime = #6:00:00 PM#
MyTime = #5:00:00 PM#

If EndTime > MyTime Then
EndTime = Format(EndTime * 1.5, "hh:nn:ss")
End If
Debug.Print EndTime

---

Larisa