Rounding (decimal) elapsed time

  • Thread starter Thread starter Gilbert DE CEULAER
  • Start date Start date
G

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
 
Hi Gilbert,

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