convert hh:mm:ss-hh:mm:ss to seconds-seconds

Assuming your data is in A2, you can use this formula:

=LEFT(A2,SEARCH(" -",A2)-1)*60*60*24 &" - "&RIGHT(A2,LEN(A2)-SEARCH("- ",A2)-1)*60*60*24

Hope this helps.

Pete

Thank you! that solved it for me.

If some of the times were entered as just mm:ss-mm:ss how can I adjust the formula?

It's a bit messy, but you could do this:

=LEFT(A2,SEARCH(" -",A2)-1)*if(len(LEFT(A2,SEARCH(" -",A2)-1))<=5),1,60)*60*24 &" - "&RIGHT(A2,LEN(A2)-SEARCH("- ",A2)-1)*if(len(RIGHT(A2,LEN(A2)-SEARCH("- ",A2)-1))<=5,1,60)*60*24

Hope this helps.

Pete