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.