A
adam
I need to determine time elasped from issue date to
response date where the cell is formatted where
A1 issue date is = 2004-04-02 15:32:37 pm
B1 response date is = 2004-04-07 08:17:34 am
=text(B1-A1,"d:h:mm:ss") gives me correct value however
since this happened over a weekend I need to be able to
only see values for workdays.
response date where the cell is formatted where
A1 issue date is = 2004-04-02 15:32:37 pm
B1 response date is = 2004-04-07 08:17:34 am
=text(B1-A1,"d:h:mm:ss") gives me correct value however
since this happened over a weekend I need to be able to
only see values for workdays.