Forum Discussion
How to convert HH:MM:SS to seconds using DAX ?
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
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 What exactly you need
Suppose if the value is 00:28:53 --> output --?
You can few more example with expected outcome
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 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
Wow! That was fast ! Thanks Vimal, you're great.