Forum Discussion
Shayz2402
4 years agoFrequent Visitor
Duration is reflecting in Time Format AM/PM
Hi, I have a Data on Google sheet which is in Duration Format and when I link this sheet with Power Bi Data Source it is reflecting in Time Format AM/PM I would really appreciate if anyone ca...
- 4 years ago
@ this is the code:
Five 9 Total = VAR _value = SUM(Sheet7[Five 9 Login TIme]) VAR _hours = DATEDIFF(DATE(1899,12,30),_value,DAY) * 24 + HOUR(_value) VAR _minutes = MINUTE(_value) VAR _seconds = SECOND(_value) RETURN _hours & ":" & _minutes & ":" & _seconds