Calculating Time Difference

[drmrinalini]

Hi,

I am trying to develop a query where my client wants to track how much
time in minutes does a nurse spend in various activities (staff
education, patient/family education, answering drug relation questions
etc. etc.) to assist nurses in other units. What query type should I
use? How do I write the query? There is a start time (when the nurse
recieves the call) and completion time (when the nurse hangs up).

Thanks
Mrinalini

 

[Ed Metcalfe]

Hi,

I am trying to develop a query where my client wants to track how much
time in minutes does a nurse spend in various activities (staff
education, patient/family education, answering drug relation questions
etc. etc.) to assist nurses in other units. What query type should I
use? How do I write the query? There is a start time (when the nurse
recieves the call) and completion time (when the nurse hangs up).

Thanks
Mrinalini

Have a look at the DateDiff() function in VBA Help.

Ed Metcalfe.

 

[Rick Brandt]

Hi,

I am trying to develop a query where my client wants to track how much
time in minutes does a nurse spend in various activities (staff
education, patient/family education, answering drug relation questions
etc. etc.) to assist nurses in other units. What query type should I
use? How do I write the query? There is a start time (when the nurse
recieves the call) and completion time (when the nurse hangs up).

Thanks
Mrinalini

DateDiff("n", StartTimeField, CompletionTimeField)

....will return the minutes between the two DateTimes.

If you use that in a Totals query grouped by NurseID and activity, and use Sum
on the above expression then you will get the total minutes per activity per
nurse.