how can i calculate hours, I have hours in very bad format, not able to unnderstand calculation.

[Balwinder_micky]

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. 

[v-binbinyu-msft]

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.

[Balwinder_micky]

Dear @amitchandak , do we have any solution to calculate hours in text format, and if we have multiple values are there a cell