[ad_1]
Perhaps something like the following:
=MINUTE(A1/60)+SECOND(A1/60)/60
More robustly perhaps,
=HOUR(A1/60)*60+MINUTE(A1/60)+SECOND(A1/60)/60
6
[ad_2]
solved Converting Times in Excel with minutes and seconds
[ad_1]
Perhaps something like the following:
=MINUTE(A1/60)+SECOND(A1/60)/60
More robustly perhaps,
=HOUR(A1/60)*60+MINUTE(A1/60)+SECOND(A1/60)/60
6
[ad_2]
solved Converting Times in Excel with minutes and seconds