Forum Discussion
What formula to use here
Hello there, I need help figuring out which formula to use here... Every day employees send me their hours for that day, which project they were working on, and for how long. At the end of the we...
DylanTowbes I had to make a reference table in the side that you can hide or cut to a different sheet.
basically recognizes time as numbers before "_hr" and project names as characters after "Project_" (underscore Being a space)
- Thank you so much for this, I really enjoy the functionality of it. I am having a hard time tracking some of the formulas haha but that's due to my basic knowledge of formulas.
