startdate, enddate to display the duration such as 0 days 01:01

[Mitchell_Collen via AccessMonster.com]

This may seem like a simple query function to many of you. However, I have
yet to find the solution.

I am trying to convert these fields: startdate,enddate to an exact duration
such as:

startdate enddate duration
06/11/07 07:00 - 06/11/07 08:01 ---> 0 days 01:01

I have tried datediff but I end of getting totals such as 1 hour or 61
minutes. ( never 01:01)
I think this is because I cannot find outside datediff(h,startdate,enddate) <-
- I have tried h, n, mmdd, nn, tttt, as formats but I can't get it right.

Please help me.

Thanks, Misty

 

[Duane Hookom]

You might want to check out Doug Steele's more complete date diff function at
http://www.accessmvp.com/djsteele/Diff2Dates.html.