help again

S

stevendavina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert decimal figure to minutes and seconds 3
How to convert number in to time lenght, minutes and seconds? 3
Convert Text in cell to hh:mm:ss 12
Difference between two times in seconds 1
Displaying time gaps 6
convert minutes and seconds (in a date format) to numbers 6
Does anyone know how to create a pace calculator (min/mile) in Exc 10
Formating seconds into mm:ss 4

Top