Power m to convert from d.hh:mm:ss to seconds

[efilipe]

Hello,

I'm trying to convent, using power M, a duration column with the format "d.hh.mm.ss" to seconds.

I used a custom column: to seconds = [Video Playtime]*86400. Worked fine, but not when I have date in "Video Playtime" column.

Any suggestions?

Thanks!

[Tahreem24 · Accepted solution]

Hi @efilipe ,

Please apply the step as per given screen shot attached.

Please give Thumbs up for Support and accept this as a solution if it helps you!

[Tahreem24 · Accepted solution]

Hi @efilipe ,

Please apply the step as per given screen shot attached.

Please give Thumbs up for Support and accept this as a solution if it helps you!

[az38 · Accepted solution]

@Tahreem24 @efilipe 

Seconds only extract second, for total seconds press "Total Seconds"

[Tahreem24]

Thanks @az38 !

Or you can try below M Code.

= Table.TransformColumns(#"Changed Type",{{"Duration", Duration.TotalSeconds, type number}})

Please give KUDOS  for Support!