Who's up for a challenge!!
A strong feeling of Deja Vue here - did something similar a good few
years back for ICL - with the additional feature that items could be
logged outside of the hours quoted, but wouldn't ACTUALLY be deemed to
start until the working hours (so logged after hours, starts the
following day) AND wouldn't include bank holidays but WOULD include
Saturdays, BUT wouldn't include time that the caller said we couldn't
use (I'm going out, so don't come till tomorrow!) - it was rather a
long formula as I recall Not sure I've got the time to work on it at
the moment though, but you might want to think about the exclusion of
public holidays bit!
|