View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 180
Default 116 minutes convert into 1.56 min

I'm not clear on the exact requirement. But a couple possibilities:
If you've got the number 116 and want 1:56, try =A1/1440, formatted as h:mm.
If you've got 116 and want "1 hr 56 min", try =INT(A1/60) & " hr, " &
MOD(A1,60) & " min".
Hopefully one of those is close enough that you can adapt to your precise
needs.

"Jomby01" wrote:

I want excel to convert 116 minutes into 1.56 min