Yes, I have the Analysis ToolPak loaded. I thought Jacob had solved my
problem but after further computations it's not exactly what I needed.

Your formula would work (I think?!) if all cells between F1 through F12 had
a date/time entry - they do not and I think the problem is with the blank
cells.

I'm trying to set up this event monitoring function so the staff entering
date/time for each of the F1 through f12 events has does not have to change
the formula.

the cells contain the following in this event sample:

D1 - D12 E1 - E12 F1 - F12 G1 - G12
10/13/2008 21:00 Monday 10/13/2008 21:30 Monday
10/14/2008 11:00 Tuesday 10/14/2008 13:15 Tuesday
10/14/2008 14:15 Tuesday 10/14/2008 16:15 Tuesday
Saturday Saturday
Saturday Saturday
Saturday Saturday
10/14/2008 14:15 Tuesday 10/14/2008 16:15 Tuesday
Saturday Saturday
Saturday Saturday
Saturday Saturday
10/15/2008 12:00 Wednesday10/22/2008 13:15 Wednesday
Saturday Saturday

Notice in this 12 step process event there are no start or end date/time
entries for processes D4, D5, D6, D8, D9, D10 and d12 9they are blank). I
think this equates to roughly 176.0 hours, I need to calculate the number of
days (24 hour periods) and display the results as 7 days and 33 minutes.
Right now your suggestion gives me the ############ error depicting negative
dates.

Any suggestions,
Mike

"Shane Devenshire" wrote:

Hi,

Try:

=F12-F1

with the latest date in F12 and the earliest in F1. FYI NETWORKDAYS
subtracts out weekends. And it is an Analysis ToolPak function in 2003 so
you would need to attach it.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"watermt" wrote:

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