Calculate time duration?

[Anonymous]

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,

Created	last_updated
09:25:01	09:31:01
09:57:17	11:12:01
12:06:00	12:25:01

[Anonymous · Accepted solution]

@themistoklis ,

Thank you for your help. Dear guest🙂

[Anonymous]

@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

[themistoklis]

@Anonymous 

Select the field --> Column Tools --> Format

Please see image below:

[themistoklis]

@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: