<div>
Assuming that each person logs the project along with the time per day, use a query to summarize by project.<br />
<br />
Select ProjectID, Sum(DailyHours) As ProjectHours<br />
From tblTimeRecords<br />
Group By ProjectID;<br />
<br />
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. &nbsp;Your result will be in hous.fraction rather than hours.minutes.<br />
<br />
Select ProjectID, Sum(cDbl(Format(DailyHours<wbr />, &quot;nn&quot;))) / 60 &nbsp;As ProjectHours<br />
From tblTimeRecords<br />
Group By ProjectID;
</div>


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;

<div>
&quot;Time Sheet&quot;, ...can mean many different things to different people...<br />
<a href="https://www.google.com/search?q=microsoft+Access+listview&source=lnms&tbm=isch&sa=X&ved=0ahUKEwjD0cnh67HTAhWKhlQKHTqHDgIQ_AUIBygC&biw=1920&bih=916#tbm=isch&q=time+sheet" rel="ugc">Different Time Sheets</a><br />
<br />
You may have to post a sample Employee time sheet, ...then post an example of the &quot;exact&quot; output you are expecting from this data.<br />
<br />
JeffCoachman
</div>


"Time Sheet", ...can mean many different things to different people...
Different Time Sheets [https://www.google.com/search?q=microsoft+Access+listview&source=lnms&tbm=isch&sa=X&ved=0ahUKEwjD0cnh67HTAhWKhlQKHTqHDgIQ_AUIBygC&biw=1920&bih=916#tbm=isch&q=time+sheet]

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

<div>
<div class="content wysiwyg-content">
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
</div>
</div>


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

to create timesheet for a project from timesheet of three employee

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.