to create timesheet for a project from timesheet of three employee

jithin v
jithin v used Ask the Experts™
on
how to create the time tracking for a project from timesheet of employees.i need to create a timesheet for a project from the timesheet of employers
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
Assuming that each person logs the project along with the time per day, use a query to summarize by project.

Select ProjectID, Sum(DailyHours) As ProjectHours
From tblTimeRecords
Group By ProjectID;

However, If you have kept DailyHours in a datetime data type. you should probably convert it to minutes first and sum the minutes and then convert back to hours.  Your result will be in hous.fraction rather than hours.minutes.

Select ProjectID, Sum(cDbl(Format(DailyHours, "nn"))) / 60  As ProjectHours
From tblTimeRecords
Group By ProjectID;
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
"Time Sheet", ...can mean many different things to different people...
Different Time Sheets

You may have to post a sample Employee time sheet, ...then post an example of the "exact" output you are expecting from this data.

JeffCoachman

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial