| 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 |
| 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 | |||
Threaded Mode
