Forum Discussion
Thomas Hochard
Nov 01, 2018Copper Contributor
Decimal hours converted to hrs/min format rounding
I'm converting decimal format hours to hrs/min format using =B10/24, and formatting the hrs/min cells using Custom [hh]:mm. Is there a formula that I can use to round up the conversion from decim...
SergeiBaklan
Nov 01, 2018Diamond Contributor
Hi Thomas,
You may use
=MROUND(B10/24,"0:01")