Project:
Starting with the classic "Daily Timesheet" project, I'm trying to add convenience features. I'm customizing how I'd like to record my daily activities for time reporting. I need fast access, quick activity entry with time stamping, and auto summing of those activities as the day progresses.
Progress to date:
I have the: auto time-stamping, pull-down list of activities, an elapsed time per activity column, and a time rounding (nearest 10th hour) function in place. All of which need some tweaking, but I'm enjoying the learning curve.
Problem #1:
How to "sort, sum, display" the totals of each, of what can be 20 individually named activities, worked several times each throughout the day. I can't seem to find the magic combination of VLookup, or Pivot Table, or data validating that will give the condensed results I'm hoping for (ignoring blank cells and non-valid activity names), without adding more clicks. This is supposed to be fast, with minimal fuss.
Problem #2 (related to #1):
How to make the elapsed time per activity "show" immediately when the next activity is selected? I know the elapsed time from the start of the previous entry is being calculated, but it doesn't display until I've entered three more activities. Something about making the next elapsed time cell the "active" cell, after selecting the next activity from the adjacent column's drop down chooser?
FYI-columns headings are: A-time stamp, B-activity (drop down list from another worksheet), C-elapsed time between consecutive entries, D-rounded elapsed time (for summing), E-percent of day spent on each particular activity.
Many thanks to all who may respond. I'm running low on Tylenol.
Starting with the classic "Daily Timesheet" project, I'm trying to add convenience features. I'm customizing how I'd like to record my daily activities for time reporting. I need fast access, quick activity entry with time stamping, and auto summing of those activities as the day progresses.
Progress to date:
I have the: auto time-stamping, pull-down list of activities, an elapsed time per activity column, and a time rounding (nearest 10th hour) function in place. All of which need some tweaking, but I'm enjoying the learning curve.
Problem #1:
How to "sort, sum, display" the totals of each, of what can be 20 individually named activities, worked several times each throughout the day. I can't seem to find the magic combination of VLookup, or Pivot Table, or data validating that will give the condensed results I'm hoping for (ignoring blank cells and non-valid activity names), without adding more clicks. This is supposed to be fast, with minimal fuss.
Problem #2 (related to #1):
How to make the elapsed time per activity "show" immediately when the next activity is selected? I know the elapsed time from the start of the previous entry is being calculated, but it doesn't display until I've entered three more activities. Something about making the next elapsed time cell the "active" cell, after selecting the next activity from the adjacent column's drop down chooser?
FYI-columns headings are: A-time stamp, B-activity (drop down list from another worksheet), C-elapsed time between consecutive entries, D-rounded elapsed time (for summing), E-percent of day spent on each particular activity.
Many thanks to all who may respond. I'm running low on Tylenol.
