Michael Adams wrote:
On Thu, 09 Apr 2009 19:55:00 -0500
Came this utterance formulated by Wade Smart to my mailbox:
Wade Smart wrote:
Wade Smart wrote:
20090409 1627 GMT-6
I have a spread sheet where I keep track of times.
Example:
E2 = start time
E3 = end time
E4 = total time(e3-e2)
G2 = start time
G3 = end time
G4 = total time(g3-g2)
There are potentially five of these sets of numbers.
What I want to do is take the initial start time at E2 and subtract
it > from either G,I,K, or M3 to get the TOTAL elapsed time.
So, for example
=(if (G3 == null) { I3 }) - E2
Something like that.
Wade
20090409 1644 GMT-6
Ah, I didnt have the syntax down right:
=(IF(G755 =0; G755; I755))-E754
Love watching people learn via email ;)
20090409 1954 GMT-6
=IF(G755 = 0; I755; IF(I755 = 0; K755; IF(K755 = 0; M755; IF(M755 = 0;
E755)))) - E754
If it is getting complex i like to relate it back to a fuller
psuedo Basic like syntax:
*** psuedo code ***
this cell content equals
if (g755 = 0;
then this = i755;
else if (i755 = 0;
then this = k755;
else if (k755 = 0;
then this = m755;
else if (m755 = 0;
then this = e755
)
)
)
)
- e754
********************
Because i lost what you are trying to do, this pseudo code method may
help you - or not.
20090409 2038 GMT-6
You got it. That is what I was trying to do.
But I was concentrating on the function and not the numbers, and had to
turn it around, starting at M755. But, it doesnt work either way.
I simplified it down but as soon as you put a IF function inside a IF
function, it stops working. I have found posts that say it can and does
work but Im just missing something :D
wade
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
