Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to count the total number of days (counting all days of the week)
elapsed between process 1 through 12. Using the m/d/yyyy hh:mm cell formatting, not all 12 processes will have a date/time entered (blank cell). When I use the following function; =NETWORKDAYS(F1,F12) and I have a blank cell (i.e., F9) I get the #Name? error. Is there a way to have the function ignore blank cells? And finally, which function do I use to count all 7 days of the week? Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate elapsed time Excel 2003 | Excel Discussion (Misc queries) | |||
EXCEL 2003 Dates & elapsed time | Excel Discussion (Misc queries) | |||
Calculating elapsed days and hours | Excel Discussion (Misc queries) | |||
Please Help With Days Elapsed And Days Remaining Calculation | Excel Worksheet Functions | |||
Elapsed time in days | Excel Worksheet Functions |