Hi All,

I have created a transaction search and was wondering if there is a way to display the number of hours, minutes or days between two fields? I want to work out the amount of time an order spends in a certain status within a department.

I have played around with a few things following the help files but it resulted in my results only displaying one line of information rather than all of my results.

My criteria is below (I have a few more Status' in there but I dont need them all in for example purpose) :

<strong>Type</strong> is Sales Order <span style="color:'"Blue"'"><strong>And</strong></span>  <strong>Main Line</strong> is True <span style="color:'"Blue"'"><strong>And</strong></span>  <strong>Date</strong> is Within This Month <span style="color:'"Blue"'"><strong>And</strong></span>  <strong>System Notes: Field</strong> is Sales Order Status (CPW BS) <span style="color:'"Blue"'"><strong>And</strong></span>  <strong><span style="color:'"Blue"'">(</span> </strong><strong>System Notes: Old Value</strong> is Awaiting Allocation <span style="color:'"Blue"'"><strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is Awaiting Credit Check <span style="color:'"Blue"'"><strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is Awaiting Stock <span style="color:'"Blue"'"><strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is Credit Check Passed<span style="color:'"Blue"'"> <strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is Credit Check Failed<span style="color:'"Blue"'"> <strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is In Despatch <span style="color:'"Blue"'"> <strong>Or</strong></span>  <strong>System Notes: Old Value</strong> is Order Cancelled <span style="color:'"Blue"'"> <strong>Or</strong></span>