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.

Business Tech Help


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


 

Looking for help with Excel formula


Charlie57

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
Charlie

Like this post
Charlie57

Likes # 0

Hey Everyone,
thanks for the help and suggestions. I am going to post a new question very soon. I am still trying to absorb all the information you guys gave me here.

Thanks again
Charlie

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Samsung Galaxy Note 4 release date, price and specs 2014

IDG UK Sites

iOS 8 features wishlist: the changes iPhone and iPad users want in Apple's iOS 8

IDG UK Sites

25 Years of the World Wide Web: Happy Birthday, Intenet

IDG UK Sites

Developers get access to more Sony camera features