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
Astéroïde

solved

DataNath
Castor

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

CSmith16
Comète

@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.

 

Révélation
417.png
Manoj_k
Comète

#417 

Screenshot 2024-03-13 195308.png

jgunter
Atome
Révélation
417_result.PNG

Solution

davidblack
Météore

Solved it!

 

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

 

Révélation
Weekly Challenge 417 Solution DKB.PNG
holly_jones12
Météore
Révélation
image.png

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

ARussell34
Astéroïde

The goal output has been created.

AR_challenge417.png