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?

Try formatting all cells as mm:ss

Format==Custom==mm:ss

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

HTH

"DW" wrote:

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?

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

DW wrote:
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?