#duration function error

[Anonymous]

Hello, I have this field in a Query

I am trying to convert it to duration using the following function:

#"Added Custom" = Table.AddColumn(#"Added Conditional Column", "aggregatetimespent_", each try #duration(0,0,0,[aggregatetimespent]) otherwise ""),

The result is this:

But I know that the result must be : 02:05:15  (DD:HH:MM:)

Any ideas how can I change the function to have the correct value ?

Thanks

[amitchandak]

@Anonymous , There are 86400 sec , looking at that number seem fine for 76500 ?

[Anonymous · Accepted solution]

I discovered that days are working days so 1 day = 8 hours..

Thanks anyway!