I help to calculate elapsed time in a query. The Start and End Times are being stored in the Short Time format. I need to get the elapsed time in Hours, such as 1.25 hours.

Thanks,

Ray

Where is the query running from, and where are you storing the values?

What you need to do is create seperate variables for start and end time and take their values before and after the query runs. Like:

Start Sub
Dim tStart, tEnd As Date

tStart = Now()
'post to table

'Run routine

tEnd = Now()
'post to table
'or calculate DateDiff()

End Sub


I use date/time since your query may run overnight?

Did this help any?

mmcdonal

The values are stored in a table. They will be entered using a form and we are looking to calculate the elapsed time for a production process.

Ray

Sorry I cant; work on this now. Check out this article: http://office.microsoft.com/en-us/ac...102181033.aspx

Did that help?


mmcdonal

Thanks for the help, I got what I wanted using the DatePart function.

Ray