STOP > Date: Thu, 9 Apr 2009 16:35:58 -0500 > From: [email protected] > To: [email protected] > Subject: [users] If statements in calc > > 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 > -- > Registered Linux User: #480675 > Linux since June 2005 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] >
_________________________________________________________________ Téléphonez gratuitement à tous vos proches avec Windows Live Messenger ! Téléchargez-le maintenant ! http://www.windowslive.fr/messenger/1.asp
