Apple Numbers Forumlas/Charts Time Tracking
Budget: £10 – £20 GBP
We'd like to implement a time tracking system for the time we spend doing things in the business. It needs to be able to show us at a glance how much time we spend in each of the 4 areas we have broken it down into.
We have the system up and running ok, but what we would require is a something set up that automatically tracks data and formulates it into a pie chart and sub categories for each element.
We have set up 4 key elements for the business tasks which fall under:
1) Doing
2) Delegating
3) Deciding
4) Designing
The way we enter the data is shown in the photos, but any task we do gets tracked and the key numbers we would need for EACH DAY would be the total time spent on each of the 4 Ds as detailed above and an automatic percentage figure for each. We would like to be able to set up a weekly pie chart on the data so we can see very quickly where our time is spent.
The other thing we would need as this is an ongoing document and constantly being added, is the sheet would need to be able to accommodate new information being added and create new automatic calculations based on the new data.
As the 'Date' is going to be used a lot, we would like a formula to be able to drag the date into columns below to copy the same date, as when we try this now it changes the below column to the next day, instead of the same date.
Lastly, we would like to be able to just enter numbers into the 'Total Time' column and it to automatically populate into the 'Each Day Total Time' columns (in accordance with the 4Ds).
Or if we can get a formula set up which calculates the Total Time when we type in the start/finish times that would be extremely helpful.
In short, we just want to track our hours and to be able to instantly see in a weekly pie chart. We can manually enter client details etc, its the time and type of job that are the key values we need here.
We have the system up and running ok, but what we would require is a something set up that automatically tracks data and formulates it into a pie chart and sub categories for each element.
We have set up 4 key elements for the business tasks which fall under:
1) Doing
2) Delegating
3) Deciding
4) Designing
The way we enter the data is shown in the photos, but any task we do gets tracked and the key numbers we would need for EACH DAY would be the total time spent on each of the 4 Ds as detailed above and an automatic percentage figure for each. We would like to be able to set up a weekly pie chart on the data so we can see very quickly where our time is spent.
The other thing we would need as this is an ongoing document and constantly being added, is the sheet would need to be able to accommodate new information being added and create new automatic calculations based on the new data.
As the 'Date' is going to be used a lot, we would like a formula to be able to drag the date into columns below to copy the same date, as when we try this now it changes the below column to the next day, instead of the same date.
Lastly, we would like to be able to just enter numbers into the 'Total Time' column and it to automatically populate into the 'Each Day Total Time' columns (in accordance with the 4Ds).
Or if we can get a formula set up which calculates the Total Time when we type in the start/finish times that would be extremely helpful.
In short, we just want to track our hours and to be able to instantly see in a weekly pie chart. We can manually enter client details etc, its the time and type of job that are the key values we need here.