Adding up times from a Triathalon

D

DW

I work at a camp where we do a triathalon in which two of the times are
weighted to make them more significant comparted to the largest even, which
is the cycling. My current formula is
=SUM(C11,PRODUCT(D11,10),PRODUCT(E11,3))
However, in order to get this to work correctly I have to put the times
(i.e. 22:04, 0:26, & 2:15) into seconds (i.e. 1324, 25.9, & 135) by hand and
then covert the final sum (1988) back into time format (33:08), once again by
hand. I tried converting my table into TIME, but it sets my times to clock
times using AM and PM as opposed to the number of minutes and seconds I was
going for. Any suggestions on how to make my spreadsheet work?
 
T

Toppers

Try formatting all cells as mm:ss

Format==>Custom==>mm:ss

Enter 22:04 as 0:22:04 i.e 0 hours

HTH
 
P

Pete_UK

Assuming you have times in C11, D11 and E11, then try this formula:

=SUM(C11,D11*10,E11*3)

and format the cell as time.

Hope this helps.

Pete
 
Top