Assuming that the format is consistent, try...

=SUMPRODUCT(MID(A1,{1,3,6,8},2)/{24,1440,-24,-1440})

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=374055