Please help on how to calculate total down time and total production run time from table????

[Alphix]

I am trying to calculate total down time and total production running time per employee. My table's field names are as follows:

(ID) (User_Name) (Event) (Time_Stamp) (Down/Running)
1 Mark Start Production 7:00:00 AM Running
2 Jill Start Production 7:00:00 AM Running
3 Rich Start Production 7:00:00 AM Running
4 Mark Machine Failure 8:00:00 AM Down
5 Rich Out of Parts 8:10:00 AM Down
6 Mark Start Production 8:20:00 AM Running
7 Jill Changeover 8:45:00 AM Down


8 Mark Start Production 9:00:00 AM Running
9 Rich Start Production 9:10:00 AM Running
10 Jill Start Production 9:15:00 AM Running
11 Mark Clock Out 12:00:00 PM Down
12 Jill Clock Out 12:00:00 PM Down
13 Rich Clock Out 12:00:00 PM Down

Questions:
(1) How do I create a selective query which calculates Mark's Total run time and Down Time?
(2) How do I do the same for the others individually?
(3) How do I create a form showing the accrued or total down time and run time as it happens?

Please help, I need some ideas....

Thank you.....

[ranman256]

1st your TIME_STAMP needs to be DATE and TIME. It currenly only has TIME. Change the default setting for this field to NOW(). This will help separate work days too.

But I will send code to calc elapsed time momentarily.

[June7]

Pulling data from another record of same table is tricky. Review http://allenbrowne.com/subquery-01.html#AnotherRecord

[ranman256]

elapsetime.zip

This saves elapsed time to a table, but DO put data and time in the TIME_STAMP field.

[Alphix]

A million thank yous. I will study your code to see how it works and gain some understanding.

After I input the date and time, do you think I can also run it by date?