It's free to register, to post a question or to start / join a discussion
Looking for help with Excel formula
Likes # 0
Posted December 23, 2008 at 4:22AM
At the end of the day our employees turn in a time sheet that list the "Task Number" and the "Time Taken" time will be written as 1.50, 2.25, 3.75 etc. One employee might work the whole eight hours on one task, turning in a time sheet that will read Task Number 100, Time Taken 8 hours. Another may do 12 task working as little as .25 hours on a task.
I would like a basic data entry sheet where we can key in the task and time each day. Then the formula would find all task "101" for instance and add all the "time" for the day for that task.
What would really be cool is that we key in the whole time sheet including name and date for all 15 employees, then we get a report that shows how much time was spent on each task. Then keep the task totals ongoing through out a project build. When the project was done we could run a summary report and see all times on all task and see each task each employee worked on.
Am I asking too much? Maybe there is someother software out there?
Thanks for any help
Reply to this topic
This thread has been locked.