Convert SECONDS in a measure to hh:mm:ss

[sw123]

Hi,

I have this measure to calculate the time difference between a start time and an end time:

Timediff = DATEDIFF(MIN('Report'[start_datetime]), MAX(Report[end_datetime]),SECONDS)

I can only manage to show the results in either hours, minutes or seconds. Is it a way to display the difference in hh.mm.ss.?

Thankful for help!

[amitchandak · Accepted solution]

@sw123 , Simple diff should give in time format

MAX(Report[end_datetime]) - MIN('Report'[start_datetime])

[sw123]

Thank you! This also displays some kind of date though... All dates are 13.12.1899. The time is fine, but how do I get rid of this noncense date?

[sw123]

Ok, this was just a matter of formatting 😄 I am suffering of a bit of holiday brains here 😄 Thanks! I am happy now.