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
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
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
Just some general info on dates and times and their calculation from MS
http://support.microsoft.com/d…n-us;214094&Product=xlw2K
HTH
Don’t have an account yet? Register yourself now and be a part of our community!