Wanting To Calculate All Hours Worked On A Project With Timesheets
(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.