![]() I start a new spreadsheet every year.Ī client information notepad, used to record contact information about clients like assigned passwords, database info for my various websites, FAX numbers, and other information that’s useful to have in the day-to-day. And, it also works as a pretty decent day-to-day To-Do List that allows for slippage. ![]() I start from January and close it at December. The spreadsheet is also designed to be easily sorted so I can extract per-project hour information. ![]() The time entry system uses 2400 time in 15-minute increments, and fractional hours are calculate automatically. I make a new one every year, and archive the old one.Ĭurrently, I use three kinds of worksheets in my Time Tracker workbook, but you can do anything that makes sense for your job of course!Ī scrolling Time Sheet, used to record time spent in each project in quarter-hour increments. Since it’s just an Excel spreadsheet, you can attach whatever additional information you need, which makes it a nice one-stop reference for all my time accounting. Using 2400 time, the spreadsheet uses tricky formulas to make calculating time easy in 0.25 hour increments for billing purposes with a line like 1215 research data structure in use 1415, which translates to “from 12:15PM to 2:15PM, I researched data structure for the client”. Unlike most job tracking spreadsheets, there is a single line to enter the starting/ending time for a task, which looks a lot better and is faster to edit. The basic idea is pretty simple: use Excel as a piece of magic graph paper.įor my freelance time-tracking, I have a bunch of jobcodes that I use to tag the work I’m doing for a particular project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |