Solved: Time calculation

[Cyberdude]

Here's a function for you to try:
[vba]Function TimeDiff(ETim As Date, LTim As Date)
Application.Volatile (False)
If LTim - ETim > 0 _
Then TimeDiff = Format(LTim - ETim, "h:mm") _
Else TimeDiff = Format(1 + LTim - ETim, "h:mm")
End Function [/vba]
where ETim is the "early" time and LTim is the "late" time.