Home > Forum Home > Presenting and Reporting Data > wanting to calculate all hours worked on a project with timesheets Share

Wanting to calculate all hours worked on a project with timesheets

Excel Help for Wanting To Calculate All Hours Worked On A Project With Timesheets in Presenting and Reporting Data


Forum TopicPost Reply Login

Wanting To Calculate All Hours Worked On A Project With Timesheets

Rate this:
(3/5 from 1 vote)
Confused Is it possible to combine a timesheet with our project list so we can figure up how many total hours we have worked on a job? again, im not sure how to post our spreadsheet on here, we already have it put together just don't know what formulas to use... so I can email you what we already have thanks
 Jeanette
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(4/5 from 2 votes)
If you have your data as dates then then a simple formula can be used to claculate the working hours by multiplying the differenct by the working hours per day.  A more accurate way when start and finish times have hours is to use the NETWORKDAYS function.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for wanting to calculate all hours worked on a project with timesheets in the