Combination for work pattern


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:


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?


Oops you are right!

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