View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Paul is offline
external usenet poster
 
Posts: 661
Default decimal time conversions

Hi

I have decimal numbers that need to be converted to times eg 18.76 = 18 mins
46 seconds using the text formaula but I have 26.35 that equals 2.21. Why can
anyone help?