Home

CHALLENGE

%3CLINGO-SUB%20id%3D%22lingo-sub-918378%22%20slang%3D%22es-ES%22%3EChallenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918378%22%20slang%3D%22es-ES%22%3E%3CDIV%20class%3D%22user-mention-tag%22%3E%3CP%20class%3D%22user-mention-tag-label%22%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%20class%3D%22user-mention-tag-label%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%3B%20Help%20me%20with%20this%2C%20which%20is%20a%20real%20challenge.%20On%20Sheet1%20I%20have%20the%20distribution%20of%20hours%20on%20different%20days%20that%20last%202%20activities%20for%20each%20group.%20There%20are%20some%20days%20that%20do%20not%20work%20(apart%20from%20Sundays).%20On%20Sheet2%20I%20need%20two%20things%3A%20THE%20FIRST%20one%20that%20automatically%20calculates%20the%20percentage%20of%20progress%20of%20each%20group%20from%20the%20sum%20of%20hours%20from%20the%20start%20date%20to%20the%20current%20date%20(this%20is%20always%20changing).%20The%20second%2C%20that%20in%20SHEET2%20show%20the%20non-working%20dates.%20I%20attached%20the%20file.%20Thank%20youall.%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918378%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
marcialfigueroa
Regular Visitor

@Ed Hansberry 

@Sergei Baklan

 

Please; Help me with this, which is a real challenge. On Sheet1 I have the distribution of hours on different days that last 2 activities for each group. There are some days that do not work (apart from Sundays). On Sheet2 I need two things: THE FIRST one that automatically calculates the percentage of progress of each group from the sum of hours from the start date to the current date (this is always changing). The second, that in SHEET2 show the non-working dates. I attached the file. Thank you all.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies