Forum Discussion
adrianoramos520
6 years agoNew Member
Converting string ex. "117:50:00" into hours
Well. I have two collums with a start service and other with the date closed as pic below: I inserted a new collumn with the code: (h):mm:ss = var Hora= QUOTIENT('Incidentes (2)'[Segundo...
- 6 years ago
Hi adrianoramos520 ,
You could use "Split" feature to get total hours in query editor.
Here is my result and test file for your reference.
v-eachen-msft
Community Support
6 years agoHi adrianoramos520 ,
You could use "Split" feature to get total hours in query editor.
Here is my result and test file for your reference.
adrianoramos520
6 years agoNew Member
Thanks for everyone that tried to help me. v-eachen-msft its worked fine for me, and now I can perform some measures.
Thank you so much.