| Home > Forum Home > Presenting and Reporting Data > wanting to calculate all hours worked on a project with timesheets > Multiply date difference by hours per day | Share |
Multiply date difference by hours per day
Excel Help for Multiply Date Difference By Hours Per Day in Presenting and Reporting Data
| Forum Topic | Login |
Multiply Date Difference By Hours Per Day | 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 Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Multiply date difference by hours per day in the Excel Business Solutions Directory |