=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
.....Sorry revise the second part to:
If 'both' B11 and B10 contain any value at all then another condition is
tested:
If B11 < B10 then the result will be ((B11 - B10) * 24) + 24
If B11 B10 then the result will be B11 - B10
.....must read the question:)
"John" wrote in message
...
Dave,
The formula you've put in the subject looks clipped so this may not be
everything, but basically:
If B11 Or B10 are empty the result is 0 and the rest of the formula is
ignored.
If B11 Or B10 contain any value at all then another condition is tested:
If B11 < B10 then the result will be ((B11 - B10) * 24) + 24
If B11 B10 then the result will be B11 - B10
Hope that helps
Best regards
John
"Dave" wrote in message
...
This is from a time sheet download. I am trying to figure out how this
statement works.
|