Thanks David, I really hate taking over other peoples projects, but it is
what it is! I'm learning this Excel stuff as quickly as I can and really
appreciate all the help this portal provides!

Mike

"David Biddulph" wrote:

To convert your 176:00 to days you don't divide by 24, you merely format as
General or Number rather than as time. That will show as 7.33333 days (in
other words 7 days and 8 hours).
--
David Biddulph

"watermt" wrote in message
...
Ron,
I apologize for the confusion. This project was passed on to me after an
employee left abruptly and I'm still working through the functions and
formulas. I do now have a column with this formula
=SUM(H17:OFFSET(H29,-1,0)) which gives me a total of 176:00 [hh]:mm. What
I
need is to now get this converted to number of days the entire process
takes.
I'm using this formula =H29/24 and I get an answer of 7:20 (which I
believe
is 7 days and 33 minutes). But, how do I do I get that to display in the
cell in the 7 days 33 minutes format instead of 7:20 format? I presume I
need to change the Number tab in Cell Format but not sure what to change
it
to?

Thanks,
Mike

"Ron Rosenfeld" wrote:

On Mon, 15 Jun 2009 08:18:01 -0700, 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

Your questions and statements are confusing to me.

From your data layout and other comments, it appears as if you have start
times
in ColD and ending times in ColF; and that you want the total of these
elapsed
times.

It would be simple to set up another column (e.g. G) and have the elapsed
time
formula in it:

G1: =F1-D1

To get the total:

=SUM(G1:G12)

The result will be in days and fractions of a day; in your example:
7.33333 (or
7 days 8 hours)

If you want to do all this in one formula:

This formula must be **array-entered**:

=SUM(F1:F12-D1:D12)
----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl<shift while hitting <enter. If you did this
correctly, Excel will place braces {...} around the formula.
--ron