View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default How to convert decimal numbers to time format

Hi all, I need to convert decimal numbers to hh:mm format in my workbook.
For instance 3/4 hour coms in decimal .75 which I need to convert into hh:mm
in next cell, since the rest of the spreadsheet is in that format.
Can anyone help please?
Paul