Rounding (decimal) elapsed time

[Gilbert DE CEULAER]

How do I change a decimal figure (e.g. 0.63 hours) into minutes (
00:37:48 ),
AND !!!
how do I round it to the nearest minute ( 00:38 ) ?
Thanks in advance,
Gilbert

 

[SimonCC]

Hi Gilbert,

If your 0.63 value was in cell A1, try the formula:
="00:"&ROUND(A1*60,0)

 

[Teethless mama]

=ROUND(A1/24*1440,0)/1440