Challenge #417: Evaluation of Employee Working Hours

[youchun]

Here's my solution

[Ray_Pospisil]

Alteryx, SQL, pandas solution

[franc1s]

I really like the fact that you included the three solutions! Particularly interested in the pandas solution.

In terms of the ALteryx solution, I like it for its simplicity!

[Seba]

Bonus Question: it should be Employee IJ345

 

 

 

 

 

 

[roryor11]

My solution

[Axelar]

#Solution

[swethamadesh]

Here is my solution Workflow. 

Spoiler

[davidhardister]

Spoiler

 

[Carolyn]

Solved! I used "round" instead of "smartround" so my solution didn't quite match the answer. I also got my RegEx Parse almost on the first try - I was missing a "-". Very excited about getting better at RegEx!

Also, I think the instructions were a bit unclear about what to do with shifts exactly 4 hours since they're neither above nor below 4 hours but the solution treated them as below 4. 

Spoiler

 

[sophiezero]

I start with the weekly challenge 424 and come back for the old ones and get addicted to them! So much fun and also could see the solutions from different people, learned a bunch of new things, so cool!