Working hours formula

  • Thread starter Thread starter Ian
  • Start date Start date
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
 
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!
 
Back
Top