Forum Discussion
Solved
Convert day text format to time
Hi all, I have a question on how to convert text to time. To be more specific I get the data from an excel file. In this excel file i have a column which has the duration of the task. The du...
Hi Alessandro-laba ,
You can add a custom column with the below codes to get the time/duration:
= Table.AddColumn(#"Changed Type", "Time/Duration", each #duration(0,0,0, Number.From(Text.Start([Working Days],Text.Length([Working Days])-5))*24*60*60))Best Regards
Hi Alessandro-laba ,
You can add a custom column with the below codes to get the time/duration:
= Table.AddColumn(#"Changed Type", "Time/Duration", each #duration(0,0,0, Number.From(Text.Start([Working Days],Text.Length([Working Days])-5))*24*60*60))
Best Regards