ExcelBanter - Rounding (decimal) elapsed time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding (decimal) elapsed time (https://www.excelbanter.com/excel-worksheet-functions/182465-rounding-decimal-elapsed-time.html)

Gilbert DE CEULAER

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

SimonCC

Rounding (decimal) elapsed time

Hi Gilbert,

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

--
-Simon

"Gilbert DE CEULAER" wrote:

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

Teethless mama

Rounding (decimal) elapsed time

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

"Gilbert DE CEULAER" wrote:

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

All times are GMT +1. The time now is 09:16 AM.