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 convert decimal figure to minutes and seconds

hi i need a formula to convert

e.g 1 min 78 seconds to minutes and seconds in usual format e.g 2 min
18 seconds

I have a list of times all in minutes and seconds that when totalled
are tottaled in a decimal way i then need to change in minutes and
seconds