New column that shows Start and finishing time

[Anonymous]

Hi all, 



I want to create a new column that shows me the start time minus the finishied time row for row. If you see its the packed time coulmn. 
So when a new bk charge number starts, this calculation starts again row for row and the end result is shown in a new coulmn. 

I need a formlen i can use. 

thanx in advance. 

[v-piga-msft]

Hi @Anonymous,

I'm a little confused about your scenario. 

Do you want to calculate the difference between the start time and the finish time?

Based on your image, I'm a little confused about the finish time, could you give me example?

If it is convenient, could you share your data sample as table format and your desired output so that I can copy and test to get the formula of the calculated column.

Best  Regards,

Cherry

[Anonymous]

Hi, 

I can not sorry share this data, I am sorry for that. But I just want to calculate the time from row to row.  

For examble               Charge Nr            new coulmn output ( need formula for this )

13 minutes                 41111                  

20 minutes                41111                       7 minutes 

24 minutes                41111                       11 minutes

30 minutes                 41111                       17 minutes 

4 minutes                   42222

10 minutes                42222                          6 minutes

15 minutes               42222                           11 minutes





So if you see the coulmn packed time, it has same charge number but the time increases row by row. So I just want to make a calculation that sums up how much time one row used, added with the next one. 

So when a new charge number starts, it will start to calculate again 

Hope this was much more clear.

BR

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Please try this calculated column below.

Column =
VAR a =
    CALCULATE ( MIN ( 'Table1'[Minutes] ), ALLEXCEPT ( Table1, Table1[Charge Nr] ) )
RETURN
    IF ( 'Table1'[Minutes] = a, BLANK (), 'Table1'[Minutes] - a )

I'm not clear about your data type of Minutes, but you could refer to the formula above.

If you still need help, please tell me what data type of your mintue column so that we could help further on it.

Best  Regards,

Cherry