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.
--
Michael
All shall be well, and all shall be well, and all manner of things shall
be well
- Julian of Norwich 1342 - 1416
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
