Read-only archive of the All About Symbian forum (2001–2013) · About this archive

Calc Time hours minutes

13 replies · 3,996 views · Started 05 January 2008

Hello,

I look for a calculator free or shareware for ADD or Subtract hours.
ie: 12h15 + 13h55

Thanks 😊

Sorry I don't know of such an app. What I normally do is multiply the number of hours by 60. That way I'm dealing in minutes instead.

yes but, this is for a logbook for pilot and there are many many operations 😉

If you have upgraded your Quickoffice to allow file editing, you can use the attached sheet to add up hours and minutes. Put the hours in column A, the minutes in column B.

Cheers

R

Attachments: Hours.zip (1 KB)

I did not know that quickoffice had to be updated, one does that how?
and one take the file where? 😉

To upgrade the Quickoffice application that's installed on your N95, open the application (it's called Quickoffice, in the Office folder). Choose "Updates and Upgrades" from the main menu.

The upgrade costs about 25 euros, I think. You pay with a credit card directly through the application, although there are other ways. This will allow you to create and edit Word, Excel and Powerpoint documents on the N95.

To read my file, just unzip the attachment and copy the .xls file somewhere that Quickoffice can see it (I put mine in E:\Documents, for example).

I think I paid �10 or so to upgrade my Quickoffice. I mainly use the spreadsheet on it to track what I'm eating on my Weight Watchers diet. I completely forgot you could use it to make special calculations. Daft of me really, when I use QO also to calculate my WW points for each food too 🙄

Thank you Rogreb and Zxon,

I try your files Rogreb but when I ADD 59 minutes + 2, I take (999999999) ?

Is this possible to add secondes ? 😊

Yes, I've just had a look at this and there does indeed appear to be a fault in the logic, such that for some values it throws out some odd totals, yet for others it works perfectly. Not found out why though.

ok, I've looked into this a bit more and found that you can add times using the =SUM worksheet function. Just enter all of your times as HH:MM:SS, and then
use SUM to add them up. You may leave off the :SS if you prefer. By default, Excel will display the sum of times in "time-of-day" format, meaning that adding 12:30 + 12:45 will yield 01:15. You can prevent Excel from "rolling over" at 24 hours by formatting the result cell as [h]:mm which will cause it to display 25:15 rather than 01:15.

If you want to add up minutes and seconds, you must include a leading "0:" in your data. For example, enter "0:10:20" to indicate 10 minutes, 20 seconds. When you sum these times, Excel will display the sum in "time-of-day" format, meaning that adding 0:40:10 and 0:30:20 will yield 1:10:30. You can prevent
Excel form "rolling over" at the hour by formatting the result cell as [m]:ss which will cause it to display 70:30 rather than 1:10:30.

Another method of adding times is to use the TIME function. To add 1 hour, 35 minutes, 10 seconds to a time in A1, use the function

=A1 + TIME(1,35,10)

Sparx104, fantastic, it are completely what I need, thank you, thank you, thank you :icon14:

That made so a long time that I seek this calculator... 😊