Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
All the time data in Text format, while I am just trying to convert the data in Duration or decimal or time, it's crashed, do we have any solution, i am not able to calculate hours, the cell which is having more than 24 hours value and the cell which is having multiple time durations.
Hi @Balwinder_micky ,
Please try to perform a data cleaning operation first to remove the unwanted data, then reorganize the data, and finally perform a type conversion.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dear @amitchandak , do we have any solution to calculate hours in text format, and if we have multiple values are there a cell
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |