We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion


Looking for help with Excel formula


Likes # 0

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

Like this post

Likes # 0

click here

Worth a try...

Like this post

Reply to this topic

This thread has been locked.

IDG UK Sites

6 best gaming PCs 2015: What's the best gaming PC you can buy in the UK?

IDG UK Sites

Three of the most expensive Limited Edition games ever made: Who's buying a $1,000,000 game?

IDG UK Sites

The future of Microsoft Surface: What to expect from the Surface Pro 4

IDG UK Sites

Best Mac: Apple Mac buyers guide for 2015: iMac, MacBook, MacBook Air, MacBook Pro, Mac mini and...