Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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!

Anonymous
6 years ago
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

Anonymous
Not applicable
6 years ago
Anonymous Have you tried second function
Column = SECOND(table[date time])
- Anonymous
  Not applicable
  6 years ago
  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
    6 years ago
    Anonymous What exactly you need
    Suppose if the value is 00:28:53 --> output --?
    You can few more example with expected outcome

Related content