View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Solidarity1 Solidarity1 is offline
external usenet poster
 
Posts: 1
Default Integer convert to minutes.

I want to take the solution to a simple arithmetic formula, say 90/18, and
have it output as a value in minutes. I have been unable to figure this one
out. In my spreadsheet, I want the answer for 90/18 to be :05. However, all
the time functions that I have utilized (timevalue, minute, text (x, ":mm") )
are all giving me a value of :01.

Does anyone know how to make that integer display as that number of minutes?

Thanks in advance.