OpenOffice Calc is a spreadsheet software similar to Microsoft Excel that stores and analyses numerical data. Using OpenOffice Calc, you can calculate time differences by using a built-in function "DATEDIFF." This function can display the time difference in milliseconds, seconds, minutes, hours, days, months or years. Using this function is relatively simple and requires little knowledge about OpenOffice Calc.
- Skill level:
- Moderately Easy
Other People Are Reading
Things you need
- OpenOffice for PC or Mac
Launch OpenOffice Calc and open a new file.
Click on a cell and type in "=DATEDIFF(" to begin the "DATEDIFF" function.
Choose the unit of time you wish to display the time difference in. This is referred to as the "string." The string 'ms' refers to milliseconds, 'ss' to seconds, 'mi' to minutes, 'hh' to hours, 'dd' to days, 'mm' to months, and 'yy' to years.
Type in the required data for the function. The data includes the "string," "datetime1," and "datetime2." "Datetime1" and "Datetime2" refers to the two times you wish to find the difference between. For instance, if you wish to find the time difference between 2010 March 01 and 2010 April 26 in terms of days, you would type "=DATEDIFF('dd','2010-03-01','2010-04-26')" in the cell.
Press the "Enter" key and the time difference should be displayed in the cell.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for