Calculating time?

Question

I'm looking for a calculator to help me add and mostly subtract time in the hour:minute:second format. Something either online or that I can run on my computer off line. Best would be a formula I could insert into a spreadsheet - Microsoft Works.

Answer 1

You must change the cell format to date/time and enter them in correctly. Here is an actual reference to explain:
http://support.microsoft.com/kb/q138731/

Answer 2

put the hours, minutes and seconds into separate cells. Create a cell that adds the hour cell x 3600, the minute cell x 60 and the second cell. This will give you time in seconds. Create another set of cells for Time2, convert them into a single cell of "seconds" like the first described above, then do all your adding or subtracting in seconds. Your answer can then be displayed in three new cells by taking the answer you generated as total seconds added/subtracted and putting the integer resulting from dividing the total seconds by 3600 (truncate the decimals), the integer that results from subtracting the integer in the hours column you just calculated x 3600, then dividing the remainder by 60 and show the answer as an integer (truncate the decimals) in the minutes column, then subtract the hours x 3600 and the minutes x 60 from the total number of seconds and show the result in the seconds column.

Answer 3

Microsoft works supports hh:mm:ss format, so all you need to do is format a column for this. You can then add or subtract at will. It can also convert from hh:mm:ss to decimal fraction of a day, and back.

Answer 4

You for mate your cells in the spreadsheet to hh:mm:ss, after wards you can ad,substract, multiply ect. at your own will, like any other values