Forum Discussion
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 a...
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 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.