Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NEEDING FORMULA Please | Excel Worksheet Functions | |||
Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
How can I use replace(alt+H) for mutiple items needing replace | Excel Worksheet Functions | |||
New user needing help with coming up with a formula | New Users to Excel | |||
Would be nice to download templates w/o needing activeX | Excel Worksheet Functions |