waiting time

[mario-sarkis]

Dear all ,

i found it the waiting time using the interval Function but as you can See 'AM' shows in the waiting time how can i erase it ?

Starting Time   Ending Time   Waiting Time

07:42:35:90     07:43:57:89    0:01:22 AM

Waiting Time 

[Gysbert_Wassenaar · Accepted solution]

specify a time format as second parameter in the interval function: interval([Ending Time]-[Starting Time],'h:mm:ss')

[rubenmarin]

Hi Mario, you can add a format to the interval, ie:

interval(timefield, 'hh:mm:ss')

Also, in number tab of graphics you can change the format.