Hi @Anonymous ,
As what have said by @amitchandak
To convert HH:MM:SS(which is a text format) to Minutes format, you need to create a calculated column, which is as below:
Minutes =
var a = LEFT('Table'[Date],LEN('Table'[Date])-6)
var b = MID('Table'[Date],LEN('Table'[Date])-(LEN('Table'[HH])+1),2)
var c = RIGHT('Table'[Date],2)
Return
a*60+b+c/60
To convert HH:MM:SS(which is a date format) to Minutes format, you need to create another calculated column, which is as below:
Minutes =
var a =FORMAT('Table (2)'[Date2],"HH")
var b =FORMAT('Table (2)'[Date2],"mm")
var c=FORMAT('Table (2)'[Date2],"ss")
return
a*60+b+c/60
As for converting Minutes to HH:MM:SS, you can only convert Minutes to HH:MMif the minute is a whole number, or convert Minutes to HH:MM:SS format when the minute is a decimal number, such as 356.2 Minutes to HH:MM:SS,you need to create the following calculated columns:
1.convert Minutes which is a whole number to HH:MM,
Get minute = MOD('Table (2)'[Minutes],60)
Get hour = DIVIDE('Table (2)'[Minutes],60)
2.convert Minutes which is a decimal number to HH:MM:SS,
ss = ('Table (3)'[Minutes 2]-ROUND('Table (3)'[Minutes 2],0))*60
MM = mod(ROUND('Table (3)'[Minutes 2],0),60)
HH = DIVIDE('Table (3)'[Minutes 2],60)
For the related .pbix file,you can turn to the URL:
https://microsoftapc-my.sharepoint.com/:u:/g/personal/v-kellya_microsoft_com/ES2gD4Ns3PFBqoAx3s_z5rsByfWWPbE8qxwU6ok8YpLWPQ?e=9v9xCx
Hope this would help.
Best Regards,
Kelly
