3 Replies Latest reply: May 6, 2010 12:40 PM by Ferdiism RSS

    How to convert minutes into hh:mm ?

    Ferdiism

      Hello Forum,

      I am trying to figure out a way to convert time data in the form of minutes (starting at 0 at 0:00) into a time format of hh:mm (so e.g. 360 would = 6:00 , and 780 would = 13:00 etc).

      I have tried to use the MakeTime formula, but I must be doing it wrong. My approach was this:

       

      MakeTime(Floor(TIMEinMINUTES/60),60*((TIMEinMINUTES/60)-Floor(TIMEinMINUTES/60)))


      Any suggestions and help would be greatly appreciated!

      Thank you very much,

       

      Ferdi