Wanting To Calculate All Hours Worked On A Project With Timesheets
Rate this:
(3/5 from 1 vote)
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
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 Excel Helper 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 Excel Business Solutions Directory
