Hi all,

I've got two columns with the dates and times a case was closed. I need to work out the amount of time that passed between the case being opened and the case being closed, but I also need this to take into account weekends and holidays. At present the formula being used (I've inherited this spreadsheet) is NETWORKDAYS, which works to some extent, but the issue we are having is if a case was logged at 17:50 on 7 March and then closed at 08:30 on 8 March, this returns a value of 2, when really we'd want that to return zero. I need it to count a working day once 24 hours has passed. Is this possible, been trying to work this out for a while but now my head has stopped working.

Thanks in advance as always

Jon