LWN.net Logo

OpenOffice.org Calc functions, part 1: Understanding functions (Linux Journal)

Bruce Byfield introduces OO.o Calc functions in part one of a Linux Journal article series. "A function is a pre-defined calculation entered in a cell to help you analyze or manipulate data in a spreadsheet. All you have to do is add the arguments, and the calculation is automatically made for you. Beginners might be content to use Calc for lists, but, for advanced users, functions are the main reason for spreadsheets. If you understand functions, then you can start to use the real power of a spreadsheet. In Part 1 of this article, I'll give a brief overview of functions and how they operate."
(Log in to post comments)

OpenOffice.org Calc functions, part 1: Understanding functions (Linux Journal)

Posted Sep 12, 2007 19:22 UTC (Wed) by TomSky (guest, #47336) [Link]

I am trying to make a time sheet that all I have to do is put in the time start and time finished with wor and have it put in the hours in another section, I have it set so that if I calculate the hours per day by hand it will give me the weekly hours I just can't get the spreadsheet to calculate the hours based on a military time format. if I put in 1900in one box then 0000 in another it will not come up with 5 for the hours. help me please
---

No man is an island, entire of itself; every man is a piece of the continent. John Donne

Copyright © 2007, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds