Assume they are in A1:A2 and the format is always the same with spaces, Hrs,
Mins and -

=SUMPRODUCT(--SUBSTITUTE(SUBSTITUTE(MID(A1:A2,FIND("-",A1:A2)+2,255),"Mins",""),"Hrs",":"))

--
Regards,

Peo Sjoblom

(No private emails please)


"teastman" wrote in
message ...

12/31/05 - 08 Hrs 10 Mins
01/01/06 - 01 Hrs 00 Mins

How do I add these two fields ? I don't need the date, just adding the
times.


--
teastman
------------------------------------------------------------------------
teastman's Profile:
http://www.excelforum.com/member.php...o&userid=30030
View this thread: http://www.excelforum.com/showthread...hreadid=497168