inonothing
New Member
- Joined
- Mar 28, 2013
- Messages
- 1
Hello!
I currently a service member and I am trying look for ways to improve how fast my base can complete patient physicals. I have created a form function that inputs the last 4 digits of a patients social security number and the time which they checked out and the time they checked in. I end up with 4 columns of data (last 4, Time out, Last 4, Time in). I am trying to find out how long it takes for each person(indicated by the last 4) to go through my exam process. My hope is to find the average. Now that would be easy if the patients checked in and out in the same order, but they don't. How do I correctly calculate the average? Furthermore, I want it to ignore records that haven't been checked back in.
Your thoughts and Ideas are greatly appreciated! [TABLE="width: 500"]
<tbody>[TR]
[TD]Last 4
[/TD]
[TD]Time out
[/TD]
[TD]Last 4
[/TD]
[TD]Time In
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]7:45AA
[/TD]
[TD]1236
[/TD]
[TD]8:00AM
[/TD]
[/TR]
[TR]
[TD]1235
[/TD]
[TD]7:50AM
[/TD]
[TD]1234
[/TD]
[TD]8:15AM
[/TD]
[/TR]
[TR]
[TD]1236
[/TD]
[TD]7:55AM
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I currently a service member and I am trying look for ways to improve how fast my base can complete patient physicals. I have created a form function that inputs the last 4 digits of a patients social security number and the time which they checked out and the time they checked in. I end up with 4 columns of data (last 4, Time out, Last 4, Time in). I am trying to find out how long it takes for each person(indicated by the last 4) to go through my exam process. My hope is to find the average. Now that would be easy if the patients checked in and out in the same order, but they don't. How do I correctly calculate the average? Furthermore, I want it to ignore records that haven't been checked back in.
Your thoughts and Ideas are greatly appreciated! [TABLE="width: 500"]
<tbody>[TR]
[TD]Last 4
[/TD]
[TD]Time out
[/TD]
[TD]Last 4
[/TD]
[TD]Time In
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[TD]7:45AA
[/TD]
[TD]1236
[/TD]
[TD]8:00AM
[/TD]
[/TR]
[TR]
[TD]1235
[/TD]
[TD]7:50AM
[/TD]
[TD]1234
[/TD]
[TD]8:15AM
[/TD]
[/TR]
[TR]
[TD]1236
[/TD]
[TD]7:55AM
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]