What is the formula to convert seconds (89 seconds) to minutes and seconds (1.29)? Thanks
B Brian Dec 9, 2004 #1 What is the formula to convert seconds (89 seconds) to minutes and seconds (1.29)? Thanks
R Ron Rosenfeld Dec 9, 2004 #3 What is the formula to convert seconds (89 seconds) to minutes and seconds (1.29)? Thanks Click to expand... If you want to keep it in that decimal format, then: =INT(A1/60)+MOD(A1,60)/100 and format as a number with 2 decimal places. --ron
What is the formula to convert seconds (89 seconds) to minutes and seconds (1.29)? Thanks Click to expand... If you want to keep it in that decimal format, then: =INT(A1/60)+MOD(A1,60)/100 and format as a number with 2 decimal places. --ron
