| View previous topic :: View next topic |
| Author |
Message |
OriginalNick
Newbie
Joined: 30 Nov 2006
Posts: 1
|
 Posted: Thu Nov 30, 2006 1:20 pm Post subject: Logbook issues |
 |
|
Hello everyone
I am relatively new to open office, so if anyone can help, please explain in simple terms 
I am making a spreadsheet to keep track of my logbook wich works great, but I would like it to somehowautomaticly recognize the type of aircraft I enter (I have a column for type of aircraft) and then add them up so that I can see total time on each type of aircraft.
Anyone think this is possible?
Thanks for you help 
Nick |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Nov 30, 2006 1:54 pm Post subject: |
|
|
What about the other columns, the date/times in particular?
Is it like this?
Date Start_Time End_Time Aircraft ...
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Thu Nov 30, 2006 4:13 pm Post subject: Re: Logbook issues |
|
|
| OriginalNick wrote: | (I have a column for type of aircraft) and then add them up so that I can see total time on each type of aircraft.
|
You might check out the SUMIF() function in the Help file for a start.
David. |
|
| Back to top |
|
|
|
