Forum Discussion
HansVogelaar
MVP
m_tarler
Aug 16, 2024Steel Contributor
HansVogelaar as long as we are throwing out a life line, maybe we can call on a few other active contributors SergeiBaklan , Patrick2788 , @JKPieterse , @djclements . can anyone help me understand why my MAP or MAKEARRAY functions don't produce the counts for each time slot in my LAMBDA above? thank you.
- Patrick2788Aug 16, 2024Silver Contributor
There's two things that are holding me back for indulging in this adventure:
1. The data arrangement is not ideal. Why are the start/end times in the same cell?
2. What is the desired goal/return from the formula?
I suspect this could be made a lot simpler by arranging the data vertically in 4 columns: Employee, Start, End, Duration. Much easier to analyze and a Gantt (Stacked column) chart could be created.