Tris543

I made a Google Sheets Delta template that anyone can use. I notice like 600 people playing were asking, on so many threads and posts, Youtube Videos of comments asking for delta time conversion, and believe I had to make one, and help everyone. Excel I expect everyone has but some don't and use OpenOffice or Google Sheets, the only problem with that is the UI interface is not like Excel So the codes used WILL NOT WORK on open-source Software/Web interface. So the template below will work well for what you need to do as of today. Everything is explained in the comment and Please don't edit it, as it will break the template if you do. So make a copy of this template. Hope this helps you. Click the link for the template: Delta time Template.

That Helpful to have and excel is a really good tool. The only thing with the code [mm]:ss,000 or ss,000 (This doesn't work) on google sheets. You can also [m]":"ss","000 for Google sheets and this is the only custom format that worked for me. I don't know why your code doesn't work, I do know there some thing that you can't do like making a shape into a button and making a vlookup doesn't work (sometimes), and the only ='Sheet1'!field1:field2 (Sheet1 can be renamed) will work as a vlookup. "google".