If you need to change some numbers into nicely formatted hours in Google Spreadsheet, then this article is for you.
So let us say I calculate some time in minutes and want to print it as a nicely formatted hour. This is the formula that makes it happen (where A2 is the cell number to convert):
=CONCATENATE(QUOTIENT(A2, 60), “:”, if (MOD(A2, 60) < 10, CONCATENATE(“0”, MOD (A2,60)), MOD(A2,60)))
The result looks like this:
If you know a better way to do it, let me know, please!