Desperately needing furmula help
Hi,
I need to figure out how to add time while taking into consideration that
there are weekends and limited work hours. Here's what I have...
Row E13 Row F13 Row K13
01/26/2007 3:41 PM 01/29/2007 12:47 PM 2 days 21 hours 06 minutes
-- The formula for Row K13... =IF(F13<FALSE,F13-E13,"")
With respect to the length of time, the 27th and 28th were weekend days and
the normal work hours are from 8 to 5. How do I get the formula to subtract
the amount of time that the weekends and off-work hours constitute so that I
come up with a true and accurate amount of time that the user had expended?
Thanks So Much,
Fred "Djinn"
|