Convert day text format to time

[Alessandro-laba]

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

[v-yiruan-msft · Accepted solution]

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

[amitchandak]

@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)