Originally Posted by
Doug28450
I want to take a swim time that is minutes:seconds.hundreths (3:32.25) and have Excel add ten percent to that time. I'm thinking there is a way to do it without converting the minutes to seconds, adding ten percent, then converting back.
Just format the cells/columns HH:MM:SS. When doing your calculations, plug in your values and, in another column, where you want your desired 10% addition, multiply the cell by 1.1.