Skip to main content

I’m trying to put together a time tracking system. Primarily need help with rollup summary tables. Probably one time situation, although there could be follow on work at some future point.


Here are the current tables:




  • Projects table: allocated time per Month and per Week per Project (we get a contract for project and enter the Hours allocated per Month and Week, contains Project Start Date and End Date)




  • Tasks table: manual task entry with Date, Actual Hours worked




  • Project Hours Logged table: manual daily time entries of hours against projects




Work Needed:




  • Project Hours Logged table: would like to replace manual entry with rollup of Hours per Day and Week from Tasks




  • Summary Hours table: rollup of Project Hours Logged by Week and by Month per Project to show what our utilization of Hours used compared to what Hours were allocated within Projects table (by Week and by Month)




Example:


Projects table contains:

Proj1 (name of project)

20 Hours allocated per Month

5 Hours allocated per Week


Tasks table contains task entries:

graphic design 2 hours May 6, 2019 (Proj1)

web design 10 hours May 6, 2019 (Proj1)

web design 1 hours May 15, 2019 (Proj1)

web design 8 hours May 22, 2019 (Proj1)


Project Hours Logged table should contain rollups:

Summary by Weeks:

Proj1 May 2019 Week#1 12 Hours

Proj1 May 2019 Week#2 15 Hours

Proj1 May 2019 Week#3 8 Hours

Proj1 May 2019 Week#4 0 Hours


Summary by Months:

Proj1 May 2019 21 Hours Worked, 20 Hours Allocated

Proj1 June 2019 0 Hours Worked, 20 Hours Allocated

Hi @Jeff_Kemp


This sounds like something I’ve done before actually and your request seems very doable. I do have the availability to get started right away.


Would you be available to schedule a call so we can discuss your project in detail so I can hear your ideas and provide a price and turn around time to get this going.


If you’d like to discuss your project, please schedule a free consultation with me via this link:


https://calendly.com/ericwebdesigner


You can also connect with me on linkedin - http://linkedin.com/in/eckline


Best,

Eric Kline

Hi @Jeff_Kemp


This sounds like something I’ve done before actually and your request seems very doable. I do have the availability to get started right away.


Would you be available to schedule a call so we can discuss your project in detail so I can hear your ideas and provide a price and turn around time to get this going.


If you’d like to discuss your project, please schedule a free consultation with me via this link:


https://calendly.com/ericwebdesigner


You can also connect with me on linkedin - http://linkedin.com/in/eckline


Best,

Eric Kline


Hi Eric, sure can schedule a call. I understand projects typically can be billed hourly or project based. Can I get an idea of your rates?

Hi @Jeff_Kemp,


Would working with groups be an option? Just an idea.


Hi @Jeff_Kemp,


Would working with groups be an option? Just an idea.



Thanks, I do have groups set up. What I need is not just a sum by group but a comparison of hours by week and month to what was allocated on another table.

Reply


Terms & Conditions