MrExcel Publishing
Your One Stop for Excel Tips & Solutions

dividing minutes into hours:minutes


Posted by Roni on August 02, 2001 6:30 AM

This is probably very simple, but apparently I'm even simplier.

I want to take a certain number of minutes, say 143 and have EXCEL break it down into hours, minutes (2:23). I tried dividing by 140 by60, but that gives me 2:38. HELP.

Thank you.


Posted by Aladin Akyurek on August 02, 2001 6:41 AM

One way:

=(INT(A1/60)&":"&MOD(A1;60))+0

Time format the cell of this formula.

Aladin

Posted by roni on August 02, 2001 7:13 AM

That doesn't seem to be working. I put the formula in CELL A2 and the minutes (147) in CELL A1 (b/c that's what it seems like the formula is referring to)... but all I get is 0:00.

Any other ideas.

Posted by Aladin Akyurek on August 02, 2001 7:23 AM

Replace ";" by ",". Thus: =(INT(A1/60)&":"&MOD(A1,60))+0

And don't forget time formatting A2 where you have put the formula.

Posted by Roni on August 02, 2001 7:28 AM

Thank you. That worked.