Formatting minutes into hours:minutes

  • How can I format a cell whose value is simply a number that represents the total number of minutes into an hours:minutes expression?


    For example, if the original cell value is 145, I would want it to read 02:25 for 2 hours, 25 minutes.


    Thanks in advance!

  • You may need an intermediate cell (column) to divide the source by 1440 (the number of minutes in a day). Then use a custom format of [h]:mm on the new cell and use that cell as your display cell (column)


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

  • Be warned when you use the [h]:mm format that if you want to use the hours displayed in a calculation (times an hourly rate) you will need to multiply the cell by 24 as well to get the correct amount.


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

  • You could also use the TIME function to convert the minutes.


    If cell A1 is 145, then B1 =Time(0,A1,0) would give you 2:25. Custom format B1 as Neale suggested with [h]:mm or it will display as 2:25 AM.


    .....Ralph

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!