Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I was having a few problems calculating the difference of time a few days ago
and I posted some questions and I received a lot of great help. Although, I'm still having problems. I'm not sure if I reply to a message in that old post, if anyone will see it. Not sure how that works. Therefore, I'm posting a new message. This is what I have: I don't understand why I'm getting different results when I do a paste special. When I paste the time formula into certain cells, the result is fine. Then when I paste the formula into another cell, I'm getting a result of 16.9999999999999 and Excel will not allow me to decrease the decimals places. Why is this happening and how can I get a result of 17 min.? Cell F18 = 10:17 AM Cell D18 = 10:00 AM Cell H18 = The formula is: =(((F18-D18)*60)*24)&" min." Result in H18 = 16.9999999999999 HELP! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time increments from dates during working hours | Excel Worksheet Functions | |||
calculating time | Excel Discussion (Misc queries) | |||
help with calculating overtime in a time sheet | Excel Discussion (Misc queries) | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |