Dec 04, 2019 08:28 AM
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.
Dec 04, 2019 08:41 AM
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!
Dec 04, 2019 09:23 AM
Sure - are you available tomorrow for a call?
Dec 04, 2019 09:34 AM
@nadja_stanglauer, I sure am! Please select a time that works best for you via this link: https://www.wisedesign.co/schedule/
Dec 04, 2019 10:57 AM
What you are wanting to achieve is definitely well within my area of expertise and I would be glad to help you out on it.
You can reach me on email@example.com
Dec 04, 2019 11:15 PM
Please check PM.