View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Changing a number into time

At the end of the day it becomes a bit more complicated, it could be
107minutes. This is easy to understand in it's self. Yet I need a
formulae
that would convert the 107 (which is a general number with no decimal
places)
into a time which should be 1 Hour 47 minutes


This formula will do that...

=TEXT(A1/1440,"[h] ""hours"" mm ""minutes""")

where A1 is assumed to have your 107 minute result.

Rick