Formula question - time calc

[Steve Grosz]

I am using the basic excel formula to calculate the difference between 2
dates using =(b2-b1)*1440 to get the number of minutes

Is there a way to have it calculate only weekdays? Without holidays?
(holidays might be a stretch....) and from 9am - 5pm??

Thanks!
Steve

 

[Anne Troy]

Try the NETWORKDAYS function. You must have the Analysis Toolpak turned on.
To turn it on, go to Tools--Add-ins, and check the box (not the VBA one).
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Steve Grosz]

What about number of minutes between 2 dates, minus weekends and
holidays? Is there a formula that will figure that one out?

Steve

 

[Anne Troy]

It would be the same. =NETWORKDAYS(B1,B2)*1440
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Bob Phillips]

Not quite, that ignores the time portion, and includes both days.

I think this does it

=(NETWORKDAYS(B1,C1)-1)*1440-((WEEKDAY(B1,2)<5)*(MOD(B1,1)*1440))+((WEEKDAY(
C1,2)<5)*(MOD(C1,1)*1440))

 

[Steve Grosz]

Thanks for both of your help!