Forum Discussion
Anonymous
3 years agoNot applicable
HOW CAN I GET THE FINAL TIME OF THE CALLS?
Hi everyone! I need to calculate the exact time the calls ended. I have the following data: date, start time and seconds that the call lasted. Example: 05/12/22 ; 14:30:00; 34 (sec). The "Star...
- 3 years ago
Ok lets rather do it in Power Query
Add a custom column to total the seconds
Here is the Code :
Time.Hour([Hour]) * 3600
+
Time.Minute([Hour]) * 60
+
[Second]Then
Add another Custom Column to convert it to Timeand here is the code :
#time(0,0,0) + #duration(0,0,0,[Hour converted to seconds])
Finally Change the type of the column to Time
Third Option would be this DAX
Let me know