Meeting

There is this thing I once saw on a computer at some office. Every six minutes or so It would prompt you and ask what you were doing and enter into a timesheet. This was basically to keep track of client billing and to know how much to charge clients (as they paid per minute)

Is there some sort of excel template I could find where I can enter details every five minutes or so (I don’t expect it to prompt me)

I can find templates for budgets, and weekly schedules, but nothing with a daily breakdown.

I would appreciate help from all those spreadsheet warriors out there.

Thanks for answers.

Actually you can build 1 yourself, here’s the steps
1. if your day start at say 9:00 am, put 9:00 am (space beteen 9:00 and am)in A3, in A4 put this formula = A3+1/288 , copy A4 down the column, then you’ll get a column of time in 5min. interval
2. if you want to print out the grid with the time, click the preview button, click setup button, sheet tab, check the box left to Gridlines, click ok button, click close button.
3. to prepare space for entry of each time slot, expand 1 or more column’s column width from B onward to the right to match the page right boundary, in here we only expand column B width. After back from preview, you can see the page boundary on the right of column I, click the boundary between column B and C and drag to the right page boundary, when you add a column header in B2, then in the preview you got a full page of gridlines with column A as time, and column B as enter grids.
4. then you can add the title in A1 like = "Work Journal for "&TEXT(NOW(),"dddd, dd mmm, yyyy") , besides, format the font, border, color etc to make it easy to work with in long term.
5. save the file as excel template, *.xlt , then everyday you can click the template and save the date as a file name to log your work.
Hope this helps.

One Response

1. AQuestionMark Says:
   July 21st, 2010 at 10:44 am

   Actually you can build 1 yourself, here’s the steps
   1. if your day start at say 9:00 am, put 9:00 am (space beteen 9:00 and am)in A3, in A4 put this formula = A3+1/288 , copy A4 down the column, then you’ll get a column of time in 5min. interval
   2. if you want to print out the grid with the time, click the preview button, click setup button, sheet tab, check the box left to Gridlines, click ok button, click close button.
   3. to prepare space for entry of each time slot, expand 1 or more column’s column width from B onward to the right to match the page right boundary, in here we only expand column B width. After back from preview, you can see the page boundary on the right of column I, click the boundary between column B and C and drag to the right page boundary, when you add a column header in B2, then in the preview you got a full page of gridlines with column A as time, and column B as enter grids.
   4. then you can add the title in A1 like = "Work Journal for "&TEXT(NOW(),"dddd, dd mmm, yyyy") , besides, format the font, border, color etc to make it easy to work with in long term.
   5. save the file as excel template, *.xlt , then everyday you can click the template and save the date as a file name to log your work.
   Hope this helps.
   References :

Leave a Comment