Extracting only minutes and seconds from a date

[BaronSdG]

Hi all,

I need to have on a visual on the X axess only the minutes and seconds of a date format.

I have a timestamp as 10.08.2021 00:28:00 and I tried to extract the minutes and seconds by using the MID or RIGHT formula, but they are not working as they return a string, which cannot be used in the graph as a continuous variable (the order of the time is in disorder).

There isn't a built in format to on get only hour and minutes, so how to solve it?

[amitchandak]

@BaronSdG , if this in string format Right and Mid will help

if this datetime use minute and second DAX functions

Minute([Date Time]*60 + Second([Date Time])

[BaronSdG]

Hi @amitchandak ,

So if I use Minute([Date Time]*60 + Second([Date Time]) this will return a column with minute:seconds in this format (with the coma ":")?

[amitchandak · Accepted solution]

@BaronSdG , Two ways

Time(0,minute([Date time]),Second([Date time]) )

or

minute([Date time]) & ":" & Second([Date time])

[manikumar34]

@BaronSdG , 

You can use below DAX.

FORMAT(financials[Date],"HH:MM:SS") this gives in the format 12:00:00

FORMAT(financials[Date],"MM:SS") this works for you.