>Hi,
>
> I've wanted to compute between two time intervals express in HH:MM:SS
>
>EX. 08/22/01 09:20:01 AM - 08/22/01 09:15:01 AM would give me a value
> of 08/22/01 00:05:00
>
> I'm trying to use datediff function but not working for me. Maybe
> my syntax is incorrect.
>
>
If it's on the same date (and VB6) you can use direct date arithmetic to calculate the time elapsed between two datetime values and then format it like so:
Format$(StartDate - EndDate, "hh:mm:ss")
You can probably use a combination of DateDiff() & DateAdd for this also. Although for something like this you would probably need to calculate the necessary intervals separately (days, hours, minutes and seconds) and then construct a date var with that to feed to the DateAdd.
HTH