Ben Hamilton

Excel formula to convert minutes into Hours and Minutes

On occasion I end up with an Excel spreadsheet that has a list of items, each of which has a duration. It’s easy to sum up the minutes and get a total number of minutes (see B7 in the picture below). But it would be nice to see that in “x hours y minutes.” don’t […]

Posted in How to | Tagged , , | Comments Off on Excel formula to convert minutes into Hours and Minutes