View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilbert DE CEULAER Gilbert DE CEULAER is offline
external usenet poster
 
Posts: 25
Default Rounding (decimal) elapsed time

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