| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Networkdays (working hours formula now to include holidays)
I am using a formula
=((NETWORKDAYS(C2,I2)-1)*(Z$2-Y$2)+IF(NETWORKDAYS(I2,I2),MEDIAN(MOD(I2,1),Z$2,Y$ 2),Z$2)-MEDIAN(NETWORKDAYS(C2,C2)*MOD(C2,1),Z$2,Y$2)) this gives me working hours Mon-Fri (Y and Z = start and finish times) now I need to incorporate bank holidays please can you advise what i need to do to the above formula -- nigeo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| networkdays and holidays | Excel Worksheet Functions | |||
| Calculating networkdays & working hours | Excel Worksheet Functions | |||
| how to include saturdays in networkdays formula | Excel Discussion (Misc queries) | |||
| Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
| Use networkdays INCLUDE weekends, Exclude holidays | Excel Worksheet Functions | |||
Threaded Mode
