Calculate date/time excluding weekends and Holidays

[beerw0lf]

Hello All,
I'm stuck triyng to figure this out and could use your help. I am trying to calculate the total number of days excluding weekends and holidays. In column A I have the start date (1/2/2008 9:00 am), in column B I have the End date (1/8/2008 4:33 pm). In column C I would like to display the total number of days ( to 2 places (6.45)) excluding weekends and holidays. I tried networkdays but that only gives me whole numbers. Any help will be greatly appreciated.

Thanks

 

[indiantrix]

Try this in C2, with times in A2 and B2... Format C2 to Number, 2 decimals (it may need "tweaking") - Larry
and now,the formula! =NETWORKDAYS(A2,B2)+MOD(A2,1)-MOD(B2,1)