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?
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?