Date/Time diff Calculation

M

Mark

I need guidance on what to do with this problem.

I have a turnaround time dbase with which I need to calculate total time
between steps, and then total time for all steps in the process.
My steps:
difference between completion of process to beginning of Dictation;
difference between Dictation completion to Transcription completion;
difference betwee Transcription completion to Physician signature.
My date is in the 7/25/2005 08:00 AM reporting format and I was able to
calculate the differences between steps where my product comes out "0 days 10
hours 17 min" (used TAT DraftToSignature:
Int(CSng([SignDateTime]-[DraftDateTime])) & " Days " &
Format([SignDateTime]-[DraftDateTime],"hh") & " Hrs " &
Format([SignDateTime]-[DraftDateTime],"nn") & " Min " to get this product).

What I need is to get a total time for all three steps and I don't know how
to procede.
 
M

Marshall Barton

Mark said:
I need guidance on what to do with this problem.

I have a turnaround time dbase with which I need to calculate total time
between steps, and then total time for all steps in the process.
My steps:
difference between completion of process to beginning of Dictation;
difference between Dictation completion to Transcription completion;
difference betwee Transcription completion to Physician signature.
My date is in the 7/25/2005 08:00 AM reporting format and I was able to
calculate the differences between steps where my product comes out "0 days 10
hours 17 min" (used TAT DraftToSignature:
Int(CSng([SignDateTime]-[DraftDateTime])) & " Days " &
Format([SignDateTime]-[DraftDateTime],"hh") & " Hrs " &
Format([SignDateTime]-[DraftDateTime],"nn") & " Min " to get this product).

What I need is to get a total time for all three steps and I don't know how
to procede.
Click to expand...


Why not do the same thing using the first stage's start time
and the last stage's end time??
 
Top