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

Netflix to introduce price increase: New subcribers to start with

IDG UK Sites

How to join Apple's new OS X Beta Seed Program: Run pre-release versions of OS X on your Mac

IDG UK Sites

Twitter - not news

IDG UK Sites

See Moo Studios' new animated advert for Blue Moon beer