Thread: help again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] stevendavina@whetstonelane.orangehome.co.uk is offline
external usenet poster
 
Posts: 3
Default help again

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