Hi,

I have the following formula to calculate the time between two dates, which is working great. But I would like to remove the weekends, and UK bank holidays, so it just calculates lost time from the workdays for the year.

This is my current formula...

=INT(P20-O20)&" Days "&HOUR(MOD(P20-O20,1))&" Hour "&MINUTE(MOD(P20-O20,1))&" Minutes"