MrExcel Publishing
Your One Stop for Excel Tips & Solutions

minutes to hh:mm

Posted by gerard on November 01, 2001 4:19 AM

I have a number (for example: 2391) these are minutes. Now I want them to be displayed as hh:mm (39:51). How do I do that?

Posted by Ian Mac on November 01, 2001 4:35 AM

Refer to post a few down from here, re:time conversion

Posted by Mark W. on November 01, 2001 4:52 AM

Use =A1/1440 where A1 contains your "time" value.
Format the cell containing this formula as [h]:mm