I’m not sure if this can be done at all but I’d like to work out a way to add timesheet entries to the appropriate month.
I currently receive timesheets with a week commencing date and then hours for Monday through to Sunday. I have defined which month each day of the week falls into with a formula - see screenshot:
I would now like to run a report that adds up all hours worked on any project and in any given month but I can only come up with a report that rolls up the totals in two columns which doesn’t help.
What I’ve got:
What I’d like to have:
Not sure if I’m just looking at this from the wrong angle but I can’t figure out any way to make this work and would appreciate any help on this.
Thanks a ton.
I’ve read through your request and have a solution in mind. Would you be able to chat further via free phone consultation to discuss this project in detail so I can provide a price and turn around time?
Schedule a free phone consultation via this link: www.wisedesign.co/schedule
To learn a little more about myself, please visit my website: www.wisedesign.co
If you’d like to connect with me on LinkedIn, please do so here: https://www.linkedin.com/in/eckline/
I look forward to hearing form you!