annieexcel
New Member
- Joined
- Jul 25, 2018
- Messages
- 22
Hi Everybody!
I'm trying to create a spreadsheet for tracking time information. I've gotten what I think is a good start by using this template ( https://trumpexcel.com/excel-timesheet-calculator-template/) and flowing the information to a pivot table.
Right now my entry areas hold a month's worth of time data and look like this: https://imgur.com/a/DvnSyrN
This information is flowing through to a data tab that I'm making my pivot table with. This works great - except for the fact that some of the employees here will be at multiple jobs a day (this would be the "customer name") column.
So for example "Brad" might be at Customer Name 1 from 7:00-12:00 and then at Customer Name 2 from 1:00-6:00. I've just been copy pasting this tool below and renaming "Brad - Job 2".
These employees might be at 7 jobs in one day.
Basically I'm just looking for some direction on how to make this a bit more efficient. It would be great to just enter the information and have excel know that when I'm entering my 2nd, 3rd, 4th, etc jobs to enter the time in the appropriate area.
Please let me know if there's any additional information I can provide or anything I can clarify. I'm not sure where to start so any ideas or research points would be great! Really appreciate your time reading this, thank you!
Excel Version:2010
Edit: apologies for the title.. I meant "possible" drop down question
I'm trying to create a spreadsheet for tracking time information. I've gotten what I think is a good start by using this template ( https://trumpexcel.com/excel-timesheet-calculator-template/) and flowing the information to a pivot table.
Right now my entry areas hold a month's worth of time data and look like this: https://imgur.com/a/DvnSyrN
This information is flowing through to a data tab that I'm making my pivot table with. This works great - except for the fact that some of the employees here will be at multiple jobs a day (this would be the "customer name") column.
So for example "Brad" might be at Customer Name 1 from 7:00-12:00 and then at Customer Name 2 from 1:00-6:00. I've just been copy pasting this tool below and renaming "Brad - Job 2".
These employees might be at 7 jobs in one day.
Basically I'm just looking for some direction on how to make this a bit more efficient. It would be great to just enter the information and have excel know that when I'm entering my 2nd, 3rd, 4th, etc jobs to enter the time in the appropriate area.
Please let me know if there's any additional information I can provide or anything I can clarify. I'm not sure where to start so any ideas or research points would be great! Really appreciate your time reading this, thank you!
Excel Version:2010
Edit: apologies for the title.. I meant "possible" drop down question
Last edited:
