up vote 1 down vote favorite
share [g+] share [fb]

Does anyone know of a time calculator for OSX?

I'm looking for a calculator that allows me to do this kind of math with times

  HH:MM:SS
----------
  01:15:58
- 00:15:00
+ 02:30:00
----------
= 03:30:58

Ofcourse the actualy calculations i'm looking to do are a little more complex and involve alot more data but basically adding and substracing is all it should do.

link|improve this question
71% accept rate
3  
It's supposed to be 03:30:58 at the end, right? – Daniel Beck Nov 30 '10 at 11:30
Depending on your use case, you might have success with time tracking software like "On The Job" or "Billings" – Daniel Beck Nov 30 '10 at 11:31
+1 @Daniel yes ... thanks for pointing that out, i've been staring at these kinds of numbers all day long and missed that one, hence i'm searching for a calculator easing the job :p – ChrisRamakers Nov 30 '10 at 16:02
feedback

2 Answers

up vote 2 down vote accepted

Hardly a native app, but spreadsheets like OpenOffice.org Calc and Microsoft Excel might help? Just remember that the default time formats† such as HH:MM:SS will show 26 hours as 02:00:00, and minus 2 hours as 22:00:00 or 10:00:00 PM. To avoid that:

Use square brackets in the format, for both the inputs and the results:[HH]:MM:SS. Then all you need is the SUM(..) function:

SUM and the correct time format in OpenOffice.org

† In localized versions of OpenOffice.org you might need odd formats like [UU]:MM:SS

link|improve this answer
That works wonderfully well, thanks alot arjan! – ChrisRamakers Dec 1 '10 at 13:26
A, Chris, only now I see your comment, as I needed the [MM] myself and forgot its format. More important: I've thanked the alot. ;-) – Arjan Apr 8 at 10:15
feedback
up vote 2 down vote

Could this site be of any use to you? http://www.scottseverance.us/html/time_calculator.htm

link|improve this answer
Yes, i found that prior to asking this question but alas it's usability is poor and it's webbased, if possible i'd rather use a native app if there is one. – ChrisRamakers Nov 30 '10 at 16:00
@Chris, it does allow for downloading too. That would still need a browser though. In Google Chrome on Windows you could save this as an application, but on my Mac menu File » Create Application Shortcut is disabled. Still, Fluid could help. Likewise, Mozilla Prism could achieve the same for Firefox. – Arjan Dec 1 '10 at 13:14
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.