@ FDibbins yes I saw post 2, it didn't help. I just did gave me 10415952000. As it did 0:01:20.555 * 24*60*60. So it read it is 120555*24*60*60. Whereas what I want it to do is know that ":01" is 1 minute and now that that equates to 60 seconds and then adds the 20.555 to give 80.555 which is what I want it to show is.

You say you want a sample workbook. Do you just want me attach my excel document?

Thanks for the help and forum tips