Calculate time duration?

Anonymous 

You can do this by using DAX formula.

You can show the time difference in HH:MM:SS or in mins if you want.

To show in format HH:MM:SS simply use the formula below in a column not a measure

Time_Diff = Sheet1[Time_B] - Sheet1[Time_A]

To convert the Time_Diff to minutes use the formula below in a column not a measure

Mins = HOUR(Sheet1[Time_Diff])*60+MINUTE(Sheet1[Time_Diff])

If the fields show time only make sure you change the format to time (e.g. HH:MM:SS) see image below:

themistoklis ,

Thanks for your help. The formula works for me but how do I change format to time I don't find that option?

Can you help me?

Thanks,

Pradeep