Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two times
when comparing two different times why is 00:30 minutes giving me a number like .02083333333333333333 and 0:30 minutes from a vlookup table is giving me a number like .0208333333284827 whats up with that that is why my conditional formatting is a problem ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=565366 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two times
This is caused by the floating point arithmetic engine within Excel, it is
limited in its precision (as are most other applications). The solution is to take one from the other and check that it is not greater than a small number, such as =ABS(A26-A27)<0.000001 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "changetires" wrote in message ... when comparing two different times why is 00:30 minutes giving me a number like .02083333333333333333 and 0:30 minutes from a vlookup table is giving me a number like .0208333333284827 whats up with that that is why my conditional formatting is a problem ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=565366 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing two times
Why not just use the ROUND function on the two times in your conditional
formatting formula, to force them to the same number of decimal places? From your example data, they are identical out to 10 decimal places. Do you need more precision than that? Hope this helps, Hutch "changetires" wrote: when comparing two different times why is 00:30 minutes giving me a number like .02083333333333333333 and 0:30 minutes from a vlookup table is giving me a number like .0208333333284827 whats up with that that is why my conditional formatting is a problem ed -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=565366 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avg Times in MOD fx using selected rows | Excel Worksheet Functions | |||
Comparing Calculated Times | Excel Worksheet Functions | |||
Comparing Times To Make Sure No Overlap | Excel Worksheet Functions | |||
Comparing Times | Excel Discussion (Misc queries) | |||
Comparing Times | New Users to Excel |