View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Converting time cells from Hrs:Mins:secs to minutes

Hi i am trying desperately to convert telephone logs from the format
hrs:min:secs into minutes and have had no joy. For example

i want 10:10:10 presented as 610.17 minutes

Any help will be grately appreciated

Richard