Possible Text Conversion
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
|