Can we write formulas to down a column?

lkent

Hello,

I have transaction data and am trying to get the difference between the minimum and maximum time for an order to be processed. The issue is the time data is in the same column.

Ex. Trying to get the time it takes from start to finish of order 23 which is 20 minutes.

ORDER | RECEIPT TIME

    23      | 8:55 AM

    23      | 9:15 AM

Is this possible?

Diane McElhiney

An expression has to be created. If receipt time is a measure within the expression you can DATETIME(FORMAT(DATEDIFF(minute,[Min: End Time],[Max: End Time]),'MM/dd/yyyy')).