I have a time sheet but...

  • Thread starter Thread starter hutch
  • Start date Start date
H

hutch

I have developed a time sheet.
It simply tracks time per day and keeps a running total (in decimal hours)
of time over consequtive days.
HOWEVER,
I would like the following elaborations.
I would like to have a list of generalized tasks that I could add to as
necessary.
.... then be able to enter start and end times with a task that I spent that
time on.
.... then perhaps on a different sheet show total time, total time for each
task, and percent of the total spent on each task.

Any thoughts as to how I could proceed or might there be a downloadable
example I might modify?
 
Hi Hutch!

Good resources for formulas and formats are at:



Chip Pearson:

http://www.cpearson.com/excel/overtime.htm



Dave McRitchie

http://www.mvps.org/dmcritchie/excel/datetime.htm



With a downloadable employee timesheet available at:



John Walkenbach:

http://j-walk.com/ss/excel/files/timesht.htm



The John Walkenbach reference shows a pretty picture of the output and
the downloadable version has an unprotect sheet option button that
allows you to see all the essential formulas in operation. You will
need to have security settings on Medium or Low before you can open a
fully operational version as there is some VBA code. That code is
viewable but not really necessary in terms of your being able to see
how the formulas work (and it has value in it’s own right as an
example of some VBA code techniques).

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 29th July: Dominican Republic (Father
’s Day), Faroe Islands (Olavsoka Day), Haiti (Maitresse Silverine),
Norway (St. Olav’s Day), Peru (Aymaraes). Observances: Maitresse
Silverine (Voudon).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top