| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time to decimal then rounding
JB -
Skip the MOD for time values: =ROUND((T11-R11)*24,1) -- Daryl S "JB Bates" wrote: Hi I have a formula =MOD(T11-R11,1)*24 Where T11 is 22:43 and R11 is 22:34 The difference of these time values is 9 minutes or .15. Currently I am getting the result of .1 because it is not rounding up. The result I need is .2 -- so that Excel will round .01 to .04 down and .05 to .09 up. How should I adjust my formula? Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting time to decimal | Excel Worksheet Functions | |||
| Rounding (decimal) elapsed time | Excel Worksheet Functions | |||
| converting a decimal to time | Excel Worksheet Functions | |||
| Converting decimal to time | Excel Discussion (Misc queries) | |||
| Converting Decimal to Time | Excel Discussion (Misc queries) | |||
Threaded Mode
