Forum Discussion
Extract Hours
Hi, I am getting time deviation column from data source of type text which has values like: 0 days 01:10:00 0 days 00:20:30 1 days 02:10:00 I need to calculate hours from this columns,...
jitpbi - You could create a new column that took the value of your old column and then just replace " days " with ":" and then you might be able to convert that to duration.