| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help me valuating time
I have this problem: I need to see if for exemple 17:00-16:00-1:00 = 0 Doing the direct formula the result is 0 like i want, but trying th logical way, the result is false. for exemple: if B1 - 17:00 B2 - 16:00 B3-1:00 or(b1-b2-b3=0) the answord should be true but the result i recive is *[u]false[/U*]. i know that the time expression is a fraction of time, so I transfor the cell whit the expression 17:00 into 0,708333333 and make the sam with the oders, the result of the formula wasn't 0 like i expected. How can i resolve this problem. Please help me!! -- Gonçalo Ricard ----------------------------------------------------------------------- Gonçalo Ricardo's Profile: http://www.excelforum.com/member.php...fo&userid=1530 View this thread: http://www.excelforum.com/showthread.php?threadid=27273 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help me valuating time
It's a problem with FPA, there is a limit to its accuracy.
Don't know if this is acceptable but try =(B1*1440-B2*1440-B3*1440)=0 -- HTH RP "Gonçalo Ricardo" wrote in message ... I have this problem: I need to see if for exemple 17:00-16:00-1:00 = 0 Doing the direct formula the result is 0 like i want, but trying the logical way, the result is false. for exemple: if B1 - 17:00 B2 - 16:00 B3-1:00 or(b1-b2-b3=0) the answord should be true but the result i recive is *[u]false[/U*]. i know that the time expression is a fraction of time, so I transform the cell whit the expression 17:00 into 0,708333333 and make the same with the oders, the result of the formula wasn't 0 like i expected. How can i resolve this problem. Please help me!!! -- Gonçalo Ricardo ------------------------------------------------------------------------ Gonçalo Ricardo's Profile: http://www.excelforum.com/member.php...o&userid=15302 View this thread: http://www.excelforum.com/showthread...hreadid=272737 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help me valuating time
one second would be: .0000115741
so if abs(b1-b2-b3) < .0000115741 then or maybe allow 30 seconds of variation if abs(b1-b2-b3) < .0000115741*30 then -- Regards, Tom Ogilvy "Gonçalo Ricardo" wrote in message ... I have this problem: I need to see if for exemple 17:00-16:00-1:00 = 0 Doing the direct formula the result is 0 like i want, but trying the logical way, the result is false. for exemple: if B1 - 17:00 B2 - 16:00 B3-1:00 or(b1-b2-b3=0) the answord should be true but the result i recive is *[u]false[/U*]. i know that the time expression is a fraction of time, so I transform the cell whit the expression 17:00 into 0,708333333 and make the same with the oders, the result of the formula wasn't 0 like i expected. How can i resolve this problem. Please help me!!! -- Gonçalo Ricardo ------------------------------------------------------------------------ Gonçalo Ricardo's Profile: http://www.excelforum.com/member.php...o&userid=15302 View this thread: http://www.excelforum.com/showthread...hreadid=272737 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
