| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Elapsed time | Excel Discussion (Misc queries) | |||
| Rounding up for a decimal | Excel Worksheet Functions | |||
| Rounding decimal | Excel Worksheet Functions | |||
| elapsed time displayed as a decimal | Excel Worksheet Functions | |||
| elapsed time | Excel Worksheet Functions | |||
Hybrid Mode
