Well, I need more help on these sheets. I've made two attachments (I
wish I could figure out how to imbed an image directly into the message
here...)
On sheet 1, this is the code to figure the required date for a cycle
time. This is from column F-
=IF(C3=0,"",C3+(D3/E3))
This is the code from column G, that tells me how many days between C
and F-
=IF(F3=0,"",IF(C3=0,"",(IF(ISERROR((F3-C3)*24),"",(F3-C3)*24)/24)))
I need the formula to exclude Saturdays and Sundays. Is this possible?
If possible, it would be great to have it display " x days x hours"
instead of "5.8" days.
On sheet 3, I am using the same code-
=IF(D3=0,"",IF(C3=0,"",(IF(ISERROR((D3-C3)*24),"",(D3-C3)*24)/24)))
...to tell me how many elapsed days between C and D, and still need the
same fix, as above.
Please help!
+-------------------------------------------------------------------+
|Filename: sheet3.jpg |
|Download:
http://www.excelforum.com/attachment.php?postid=4700 |
+-------------------------------------------------------------------+
--
millzenator
------------------------------------------------------------------------
millzenator's Profile:
http://www.excelforum.com/member.php...o&userid=28042
View this thread:
http://www.excelforum.com/showthread...hreadid=475490