View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JR
 
Posts: n/a
Default converting a number to time formatted as minutes

One more on this topic. How do I take a number like (97.5) and convert this
to time (97:30)


"JR" wrote:

Hello,

Would like to ask for your help. How would I go about taking a number
(formatted as general) and convert this to minutes. I have tried taking the
number divided by 60, but I cannot seem to find the right format.

Thanks