Put your two times in separate cells and subtract the cells to determine the difference between the two times. You can format the times and the answer to display in a variety of time formats.
It depends which spreadsheet package you're using, and how its syntax is set but - something like... D3=A3-B3 or D3=sum(A3-B3)
Yes.
auto calculate
Probably nothing. Sounds like semantics to me.
30 degree East and 80 degree west time difference
Spreadsheets can calculate just about anything you want. That is their purpose. If you know what you want to calculate and how to do it, then you can use a spreadsheet to do it.
A spreadsheet app has rows and columns. Word processing just goes down the page.
You can easily do this with Microsoft Excel or OpenOffice's spreadsheet module.
In Microsoft Excel, there are two calculation methods. Usually it is set to Auto Calculate, which means that every time a cell is changed, it goes through and recalculates every formula in the spreadsheet. If you have a very large spreadsheet, this can slow things down, especially if you have several cells to make changes to. If you change the settings to Manual Calculation, then you can make all of your changes, then tell it to recalculate the spreadsheet.
To calculate the change in time for a given scenario, subtract the initial time from the final time. This will give you the difference in time between the two points.
To calculate displacement from a position-time graph, find the difference between the initial and final positions on the graph. This difference represents the total displacement traveled by the object.
to organize data, draw graphs, calculate possible results