Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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