I frequently will track the time I spend on my work in my upholstery business. Up till now, I have entered my start and end times on any particular job on paper. Later, I entered the times into a spreadsheet to total all the individual times and then filed the paper for future reference.
When a similar job comes in, I can go to the file (which is arranged according to categories) and pick out a job I've done in the past to get an idea of how to price the current job.
Now, I'd like to shorten the time spent (and add security by having an easily copied file) by entering the times directly into the spreadsheet as I work. So far, it would go like this:
Fill in a list of sortable columns with Customer Name, Job Name, and Category on Sheet1. If the entries could automatically show up on Sheet2 as a heading. I would have START and END buttons to record entries of Time In and Time Out with a Sum function for totals at the bottom. I'd like to then be able to have this filed by category and be ready for the next job entry on Sheet1. Future searches would be done by sorting the column for any details I can mentally recall (which isn't getting any easier!). Most times, I'd sort the Category column to bring up all jobs done in say, the Cushions category. Then the sheet # in that row would tell me where to find that sheet.
Anyway, that's my plan so far (if I've made myself clear enough) does anyone have any ideas what formulas I'd need to plug in to do this, or maybe there is an easier way to approach it?
Thanks,
Rich