Help!-Trying to total Elapsed Time

[jmriddic]

I have been trying to help a user calculate elapsed time. I referenced the GetElapsedTime from the following Microsoft article

http://support.microsoft.com/kb/210604/

It displays ok on a form or inserting on the detail in a report like it suggests
but the user would also like to total up the elapsed time on the report. Not sure how to do that with the way this function is built.

 

[RuralGuy]

Maybe there is something useful on this page. http://www.mvps.org/access/datetime/index.html

 

[jmriddic]

update

I did some searching and one user had done this in his database in a query.

Round((table1.Endtime-table1.Starttime)*24,2) which displays in hours



Should be easy enough to based the form on the query.

Question is how would I total the times on a report in a footer because I want to display each record and the total elapsed time at the bottom in hours and minutes which I believe can be done at least on a form in a text box in this format:

=Int([ElapsedTime]) & " hr " & [ElapsedTime]*60 Mod 60 & "min"

 

[jmriddic]

help

Can someone help me?

 

[pbaldy]

Here's an example of a textbox in a footer which does the kind of thing you're talking about. The key is that it refers to a hidden textbox in the detail that has its running sum set to over all (totalling minutes):

=Int([txtrsumTimeAll]/60) & ":" & Format([txtrsumTimeAll] Mod 60,"00")