How to convert HH:MM:SS to seconds using DAX ?

[Anonymous]

I want to convert HH:MM:SS format of time into seconds.

Whenever I change it using format and use SECONDS it only gets the seconds of that time not the whole duration in seconds.

Thanks for answering! Really appreaciate it!

[Anonymous]

@Anonymous Have you tried second function

Column = SECOND(table[date time])

[Anonymous]

Hi Vimal, thanks for answering, however its still showing only seconds of the time that i wanted to convert.

Ex.

00:28:53 - im only getting the 53 seconds whenever i use the dax formala that you've given.

[Anonymous]

@Anonymous What exactly you need 
Suppose if the value is 00:28:53 --> output --?
You can few more example with expected outcome

[Anonymous]

instead of 53 seconds only, I wanted also to convert the 28min into seconds as well. So in total, I wanted a result of 1733sec.

Is there any easiest way to convert this one aside from manually compute it ?

[Anonymous · Accepted solution]

@Anonymous  Does this work for you

Column = MINUTE(Table[date time])*60+SECOND(Table[date time])

 In case you also have hours in your datetime field please extract the hour and multiple by 3600

You can also try DATEDIFF function and use second as third argument

[Anonymous]

Wow! That was fast ! Thanks Vimal, you're great.