On Thu, 5 Oct 2006 21:54:22 -0400, "Tom Ogilvy" wrote:

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

gives me
32.525 days


Very nice.
--ron