Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #417: Evaluation of Employee Working Hours

boglarkalipka
8 - Asteroid

solved

DataNath
17 - Castor

Really not sure sorry @CSmith16 - I'm not doing anything special other than using AMP. Perhaps just a difference in our systems?

CSmith16
9 - Comet

@DataNath All good, I just wanted to get the exact output and use a Crew Macro to validate but it kept throwing errors because the sort order was incorrect. Either way I got the answer just had to do it a different way, thanks for the challenge though!

ggruccio
ACE Emeritus
ACE Emeritus

I wasn't sure what to do with people who worked Exactly 4 hours, but figured it out.  Also likely could have calculated possible total shifts as part of the same workstream, but realized it after-the-fact.

 

Spoiler
417.png
Manoj_k
9 - Comet

#417 

Screenshot 2024-03-13 195308.png

jgunter
5 - Atom
Spoiler
417_result.PNG

Solution

davidblack
7 - Meteor

Solved it!

 

Response to bonus question is in a comment within my flow screenshot below.

 

Spoiler
Weekly Challenge 417 Solution DKB.PNG
holly_jones12
7 - Meteor
Spoiler
image.png

Had a bit of an issue with the non-working days and rounding as my numbers were slightly off

ARussell34
8 - Asteroid

The goal output has been created.

AR_challenge417.png