Working hours formula

I

Ian

Hi

I need a formula to calculate the total amount of working
hours between now and the 2nd of July 7 1/2 hrs per day.

Can anyone help?

Thanks

Ian
 
D

Domenic

Hi Ian,

Try,

=NETWORKDAYS(TODAY(),A1)*7.5

If there are holidays between the two dates, they can be taken into
account within the NETWORKDAYS function. For example:

=NETWORKDAYS(StartDate,EndDate,Holidays)

Also, you'll need to install the Analysis ToolPak Add-in for this
function.

Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Work Budget Salary vs Real Time Salary 0
Resource name inside resource sheet: per person, work per hours per week 0
Calculate elapsed time excluding specific timeframe 10
Calculate After hours 3
Help with a formula for a Time Sheet. 1
work hours with different hour prices 12
I need a lot of help with MS Excel 2010 2
"The object was saved in an invalid format and cannot be read." 0

Top