Your date/time format only differs by one character (the comma) from a
recognisable excel date/time format so you can easily convert by using
this formula

=SUBSTITUTE(A1,",","")+0

If you want to subtract the time/date in A1 from that in B1 and convert
to seconds....

=(SUBSTITUTE(B1,",","")-SUBSTITUTE(A1,",",""))*86400

that formula should give you a result of 8074 for your example

..although, as Fred says, you may be better off omitting the *86400 and
just formatting as time....., i.e. use just

=SUBSTITUTE(B1,",","")-SUBSTITUTE(A1,",","")

custom format as [h]:mm:ss to give an answer of 2:14:34


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543135