Try to get work hour and break hour from a single line

[WinYit]

Hi, I have a problem that I cant find works hour and break hour in my data. I only found this line: 

FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR

Now I might think that this line can get the works hour and breaks hour but i dont know how to solve it. 

2. Either can or cannot, can i separate this line to Monday, Tuesday,..., Sunday?

[sturlaws]

Hi, @WinYit,

you have not provided much context here, but assuming you are working in power bi desktop in import mode, you can solve this with power query.

Find the transform button:

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

Split the sting first by semi-colon, then by comma:

Then play around with the pivot-functions to change the columns to rows

[WinYit]

I think its cant help me. I have two questions.

1. can I get work hour and break hour from the recurrence pattern: FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR

2. can I get Day(Monday, Tuesday, Wednesday, Thursday, Friday, Saturday,Sunday) from the recurrence pattern:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR

[WinYit]

This is the work hour and break hour that i need 

[sturlaws]

If this is the data you have:

FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR

you obviously cannot get work hours and break hours directly from this, as it does not contain any information about this. 

If you can assume a fixed number of hours each day, you can use the method I described, using power query, and adding a few steps to calculate the number of hours.

Look at the attached file: