I don't know of any way to do this without first converting the time to a
decimal number first, i.e. 2 minutes and 45 seconds equals 2.75 minutes.

If you have a time value in A1, then try this in B1.

=minute(a1) + second(a1)/60

Once you've got that value in B1, you can add, multiply, or whatever you need.

"DW-WD" wrote:

I am a swimming coach and I'm trying to set up and Excel spreadsheet to help
me create practices.

A sample set is 10 x 200 on 2:45. I want to be able to calculate how long
this set will take. Knowing that each 200 takes 2 minutes and 45 seconds, I
should be able to multiply the time by the number of repeats, 10, and have a
result of 26:30 (26 minutes and 30 seconds). How can I show this in Excel?

I also want to be able to add the time of sets together to show how long an
entire practice will take. So if one set takes 25:15, another takes 26:30
and a final one takes 42:25, my cumulative time should be 1:34:10 (1 hour, 34
minutes and 10 seconds). I can't get Excel to show and calculate time other
than time of day.

Please help

Dave