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?