| Home |
| Search |
| Today's Posts |
|
#24
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing non Work Hours from Excel calculation
Hi Linda, I see Bob's done all the work here but here's a slightly different version that you could use.... =(NETWORKDAYS(A1,B1)-1)*(F1-E1)+IF(WEEKDAY(B1,2)5,F1,MEDIAN(MOD(B1,1),F1,E1))-IF(WEEKDAY(A1,2)5,E1,MEDIAN(MOD(A1,1),F1,E1)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=520487 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Calculation of full hours | Excel Worksheet Functions | |||
| how to add hours and minutes in excel | New Users to Excel | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| Need a function that separates over-lapping work shift hours. | Excel Worksheet Functions | |||
Threaded Mode
