Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate time duration?

Hi,   can you someone help me to calculate time duration, please? I am unable to calculate   I need to calculate the time duration between "Created" and "last_updated".   See the example below,...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    @themistoklis ,

    Thank you for your help. Dear guest🙂

themistoklis's avatar
themistoklis
Community Champion
5 years ago

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: