Waiting Time

[Anonymous]

The above straight tables show time between two consecutive transaction (TimeDispensed) with a unique id ScriptNumber.  The difference between the tables is the DateDispensed and Month-Year Dispensed.  I tried calculating the wait time (TRx Wait Time), time between two consecutive transactions, with the following expression:

   =(Interval(([TimeDispensed])  -  Below([TimeDispensed])),'mm : ss')

but this gives blanks as the above table shows.  How can i resolve this and then calculate the monthly average "TRx Wait Time" and graph the average monthly wait time against Month-Year?

Regards.

[prabhu0505]

Try something like this.

=Interval((Time#('8:10:20', 'hh:mm:ss') - Time#('9:00:10', 'hh:mm:ss')),'hh:mm:ss')

=Interval((Time#([TimeDispensed], 'hh:mm:ss') - Time#(Below([TimeDispensed])), 'hh:mm:ss')),'hh:mm:ss')

[Anonymous]

try this expression

=Interval(([TimeDispensed]) -  below([TimeDispensed]),'mm : ss') 

it works for me, your expreion also showed "-"

the difference is that i use additional brackets around ([TimeDispensed]) -  below([TimeDispensed]))

[Anonymous]

Many thanks, tried but gave me an expression error

[Anonymous]

Many thanks, this seems not to be working for me.

[prabhu0505]

share the application, if possible.

[Anonymous]

i used an inline table without "AM"

now I changed it. my inline  table is

TEST:
Load * Inline [
TimeDispensed
8:00:00 AM
8:10:00 AM
];

Expression in straight table is:

=Interval((time((time#([TimeDispensed],'h:mm:ss TT'))) -  below(time(time#([TimeDispensed],'h:mm:ss TT')))),'mm : ss') 

table Looks like (value is negative as Expression subtract 8:10 from 8:00!

[prabhu0505 · Accepted solution]

To accommodate AM/PM, use below format-code.

=Interval((Time#('8:10:20 AM', 'hh:mm:ss tt') - Time#('9:00:10 AM', 'hh:mm:ss tt')),'hh:mm:ss')

[Anonymous]

Thank you Saravana