| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Rounding of Formular results
I am converting minutes to Hrs & Secs but having trouble!
I have the below forumla however the minutes keep rounding out to 10 or more decimal places. =INT(V23/60)&"hrs "&MOD(V23,60)&"mins" Cell V23 = 239 Cell W23 is using the above formular which keeps spitting out heaps of decimal places for minutes 3hrs 58.9999999999999mins I am calculating cell V23 from cell R23 & S23 which is the difference between 2 times as shown in formular below. =IF(ISERROR((S23-R23)*1440)," ",(S23-R23)*1440) Not sure if this is affecting my result in cell W23. Just new at excel and would love some help please. Submitted via EggHeadCafe - Software Developer Portal of Choice HANDLING BINARY AND TEXT DATA IN XML OVER THE WIRE http://www.eggheadcafe.com/tutorials...-and-text.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| week end and week so far results formular in % format | Excel Discussion (Misc queries) | |||
| Rounding date formula results | Excel Discussion (Misc queries) | |||
| rounding the results of two times | Excel Worksheet Functions | |||
| Rounding results by ranges | Excel Worksheet Functions | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
![Tim Steven[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
