Hi,

I'm trying to create a formula which will calculate the weekday hours only, no weekends or holidays. I've seen numerous posts which mainly focus on working hours (0900-1700), but I just need weekday hours.

For example...

Start End
Fri 1/29/16 08:32 Sat 1/30/16 00:31

I would like for the formula to exclude the 31 minutes into Saturday, and provide a result (in this case) of 0.64444444. I've tried NETWORKDAYS+MOD but it's not producing the correct result.

Please, any help would be great!!

Thanks,
Bill