IF

N

Nishcas

I'm trying to set up a formula that will subtract one date
and time from another, but must be less than another
column to provide true or false. **I only want it to
count business days and hours.**

Another formula would be exactly the same except for the
less than which would be <*2.

1) 11/11/03 9:00 AM - 11/03/03 8:49 < 16:00:00, 8:00:00,
4:00:00


2) 11/11/03 9:00 AM - 11/03/03 8:49 < 16:00:00*2,
8:00:00*2, 4:00:00*2

Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top