Forum Discussion

llyons's avatar
llyons
Frequent Visitor
5 years ago
Solved

call center duration

Hello,  I have Excel data type Custom Column Number h:nn:ss from a power pivot that I have imported into Power BI. The field with duration imports as ABC 123 with data showing as 12/31/1899 12:00:01 ...
Need Help
llyons's avatar
llyons
Frequent Visitor
5 years ago

what are the formulas to do the steps you prepose,excluding the charts

MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
5 years ago

In order to keep the right 5 characters of a column:

 

RIGHT(Column, 5)

 

This will get you the time in seconds.

Column = MINUTE(Table[date time])*60+SECOND(Table[date time])

 

Divide this by 60 in order to get minutes etc.