Forum Discussion
Solved
Power BI Total Time Calculation
Hello All, I am trying to calculate overall time an agent had spent on different task in Power BI Desktop. Please help me resolve this issue. We have multiple agent who are working on different t...
Hi vsinne,
Please check out the attachment. If it's what you want?
TimeCosts = VAR total = SUM ( Table1[Seconds] ) VAR hours = INT ( total / 3600 ) VAR minutes = INT ( MOD ( total, 3600 ) / 60 ) VAR seconds = MOD ( MOD ( total, 3600 ), 60 ) RETURN hours & " hours " & minutes & " minutes " & seconds & " seconds"Best Regards,
Dale
Hi vsinne,
Please check out the attachment. If it's what you want?
TimeCosts =
VAR total =
SUM ( Table1[Seconds] )
VAR hours =
INT ( total / 3600 )
VAR minutes =
INT ( MOD ( total, 3600 ) / 60 )
VAR seconds =
MOD ( MOD ( total, 3600 ), 60 )
RETURN
hours & " hours "
& minutes
& " minutes "
& seconds
& " seconds"
Best Regards,
Dale
Thank You so much.