| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering out weekday dead time
I am using NETWORKDAYS function to determine the number of weekdays between
two dates e.g 01/03/06 to 31/03/06 =networkdays(A6,B6) gives the result 23. However i now need to detract the number of "dead hours and minutes " incurred during those 23 week days between the hours of 1800hrs to 0800hrs to give the total number of live hours and minutes incurred 0800hrs to 1800hrs on weekdays. Can you help ?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
| Time sheets | Excel Worksheet Functions | |||
| time differences in a column | Excel Worksheet Functions | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Threaded Mode
