Sum Elapsed time

[Riley]

User enters start and stop times in medium time format- stored in a table.
I want to calculate the elapsed time, which isn't too hard, but then I want
to sum the elapsed time and use that number to perform other calcs but am
stumped- help?

 

[Jeff Boyce]

Riley

"How" will depend on your definitions...

By "elapsed time", do you mean the difference between StartTime and
StopTime? What happens if the StartTime is late on one day and the EndTime
is early on the next?

What are you storing in those two fields? Not "how", as in "medium time
format", but what? Are the fields actually date/time data type fields?

If you create one query that derives the elapsed time (difference between
StartTime and StopTime), you can build a second query, based on the first,
that totals the elapsed times (from the first).

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP