Forum Discussion
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 duration of the task is reported like: 1 day; 2 days; 0.25 days and so on. Please see below screenshot:
What i would like to do would be to convert this text into 'time' or 'duration'
Is anybody able to help me?
Thanks in advance,
Ale
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
2 Replies
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
Alessandro-laba , if its only days
Split on space in power BI:https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Then new columnin power query with part 1
#duration(Number.FromText([Part1]),0,0,0)
