Seconds to Duration Format

[ab21]

Hello,

I have a query that pulls duration of a call in seconds. I've created a measure that sums the duration per employee and formatted in dd:hh:mm:ss:
1. Measure = format(sum('Table'[Seconds Duration])/86400,"dd:hh:mm:ss")

The calculation is correct for hh:mm:ss, but when the dd (days) is less than 1 it shows 30 instead of 00. Example, duration is 68 seconds. Format presents 30:00:01:08.

Is there a way to correct this?

Thanks,

 

[Zot]

I believe it would help if you can show how exactly the pulled data look like and how you calculate the duration. Perhaps copy paste few samples.