cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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

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!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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

6 REPLIES 6
Anonymous
Not applicable

@Anonymous Have you tried second function

``Column = SECOND(table[date time])``
Anonymous
Not applicable

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
Not applicable

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

Anonymous
Not applicable

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
Not applicable

@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
Not applicable

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