Time Diff between Times

[MYDATASTORY]

Hi,

Please advice, thanks in advance

I have 5 columns  TrainStartTime, TrainName, Date, and TrainFishTime  I want to calculate the exact time the journey takes Duration 

1.I would like to calculate the exact duration including the minute's train takes (HH: MM) TrainFishTime-TrainStartTime

2. Total Duration of all the train journey by month(date column)TrainFishTime-TrainStartTime Group by Date/Month

3Total Duration of all the train journey by TrainName( TrainName column)TrainFishTime-TrainStartTime Group by TrainName

Time format HH:MM:SS

The expected results for the requirement is below on the Duration column 

TrainStartTime	TrainFishTime	Duration   |  TrainName  | Date
02:20:00	02:50:00	00:30:00   | TrainA           |01/7/2020
12:30:00	01:30:00	01:00:00   |TrainB             |09/2/2020

[v-kelly-msft]

Hi  @MYDATASTORY ,

With your expected output,it seems easy to get the result by creating a column:TrainFishTime-TrainStartTime, but if you cant simply get the result by the expression,could you pls upload your .pbix file to onedrive business and share the link with us?Remember to remove the confidential informantion.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@MYDATASTORY ,

You can have column like

[TrainFishTime]-[TrainStartTime ]

for aggregation refer

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...