On Tue, 16 Jun 2009 09:29:02 -0700, watermt
wrote:

Ron,
I talked to the project leader and at this point the project team has
requested it merely be used as "display" of the length of time in days and
hours, so your formula will work perfedtly.

I only hope they do not at sometime in the future which to ude this reult in
another formula/function!

Thanks Ron!

Mike

Glad to help. Thanks for the feedback.

You won't be able to use this result in a future calculation, but you could
either use a hidden cell, or substitute the SUM formula in the future
calculation matrix. (You could even write a formula to change that text back
to an Excel date/time value).
--ron