I hoped you wouldn't be too upset <g. After a few supposedly failed
attempts to post, it got personal.



"Tom Ogilvy" wrote:

You can never say enough positive things about my solutions <g Feel free to
post away! Don't give it a second thought.

--
Regards,
Tom Ogilvy


"JMB" wrote:

Sorry - I kept getting error messages and didn't think the post was being
accepted.

"JMB" wrote:

A much more elegant solution.

"Tom Ogilvy" wrote:

With your data in A1:A5
=SUMPRODUCT(1*SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRI M(A1:A5)," days "," Jan
1900 ")," hours ",":")," minutes",""))

gives me
32.525 days

--
Regards,
Tom Ogilvy



"Rob" wrote in message
...
How would it be possible to convert the below text into a number that
Excel
will recognize as date/time?

Or...

How would it be possible to sum the below numbers given that it is
recognized as text by Excel?

7 days 19 hours 41 minutes
7 days 19 hours 41 minutes
1 days 9 hours 47 minutes
3 days 11 hours 20 minutes
12 days 0 hours 07 minutes


Thank in Advance. TOTALLY!
Rob