ExcelBanter - help again

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - help again (https://www.excelbanter.com/excel-discussion-misc-queries/186314-help-again.html)

I think i need help also!!!

I have a series of minutes and seconds time in a column e.g

1.12 = 1 min 12 sec
2.54 = 2 min 54 sec
etc
etc

When I come to total them I am aware they are totalling in values of
100, however I need to convert them back to minutes and seconds

e.g. the total of one column is 25.89 = but I need this to be in
minutes and seconds

I have a lot of coloumns so need an easy formula

How do i convert this value to minutes and seconds

Thanks

=INT(K21)&":"&INT(60*MOD(K21,1))

" wrote:

I think i need help also!!!

I have a series of minutes and seconds time in a column e.g

1.12 = 1 min 12 sec
2.54 = 2 min 54 sec
etc
etc

When I come to total them I am aware they are totalling in values of
100, however I need to convert them back to minutes and seconds

e.g. the total of one column is 25.89 = but I need this to be in
minutes and seconds

I have a lot of coloumns so need an easy formula

How do i convert this value to minutes and seconds

Thanks