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
Now I just have to get the rest of the cells in there :D
Wade
20090409 1954 GMT-6
=IF(G755 = 0; I755; IF(I755 = 0; K755; IF(K755 = 0; M755; IF(M755 = 0;
E755)))) - E754
I found the above in the oo forum but its giving wrong values.
E754 = 10:20
E755 = 10:35
G755 = 16:22
The above shows: 13:40 instead of 6:02
--
Registered Linux User: #480675
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
