Combination for work pattern

Hello

I wonder if you could point me in the right direction.

I am trying to capture all available combinations for work pattern.

I have the following format:

S0000M0000T0000W0000T0000F0000S0000

letters are days of the week starting Sunday
the first two digits would be hours in a day (max hours worked per day could be 12hrs)
the 3rd and 4th digit would be showing minutes (in decimal):

for example: S0625M0625T0625W0625T0625F0900S0000

This person works 4 days 6 hours 15mins plus 9hrs on Friday.

Where do I start from?

Hi there!

Actually this person worked 5 days 6 hours and 15 minutes if not mistaken :wink:

Not quite sure what your output should be. Sum of hours per week/list of hours per day per employee or something else?

Br,
Ivan

Oops you are right!

This one worked 5 days 6 hrs and 15 mins (Sun-Thu) and Friday 9