Hours & minutes adder
Thread Starter
Joined: May 2001
Posts: 314
Likes: 2
From: UK
Hours & minutes adder
Does anyone have a simple calculator program I could use for a computer to add up hours and minutes? I keep my log book manually and can never be bothered adding up each column at the bottom of each page and am now months (if not years) out of date on my totals. I would quite like to know how many hours I have flown.
Thanks from Oh Great Lazy One
Thanks from Oh Great Lazy One
The Oracle
Joined: Aug 2001
Posts: 2,902
Likes: 0
From: Naples, Florida U.S.A.
roundwego,
If you are looking for an easy way to add it up, put all the hours in one column and all the minutes in anther. Adding up all the hours is straight forward.
The minutes takes a couple of steps. Add up all the minutes and divide by 60. Then take whatever is to the left of the decimal point and add it to your other hours from the other column, then take the number to the right of the decimal point and multiply by 60 again.
Then you get the total hours and minutes you flew. You could make a simple Excel Spreadsheet to do this.
Take Care,
Richard
If you are looking for an easy way to add it up, put all the hours in one column and all the minutes in anther. Adding up all the hours is straight forward.
The minutes takes a couple of steps. Add up all the minutes and divide by 60. Then take whatever is to the left of the decimal point and add it to your other hours from the other column, then take the number to the right of the decimal point and multiply by 60 again.
Then you get the total hours and minutes you flew. You could make a simple Excel Spreadsheet to do this.
Take Care,
Richard
Joined: Aug 2004
Posts: 87
Likes: 0
From: UK
Assuming you have MS Excel, highlight a column, select format, then cells, category Time and in the Type column select the one that reads 37:30:55 and click OK.
Then type the hours:minutes (seperate with a colon) down that column.
After you've entered all the numbers use the "sum" function to add them all up.
Then type the hours:minutes (seperate with a colon) down that column.
After you've entered all the numbers use the "sum" function to add them all up.
Thread Starter
Joined: May 2001
Posts: 314
Likes: 2
From: UK
Thanks guys for taking the time to reply. I did try Excel but whatever I did ended up a bit clumsy. I knew the arithmatic but didn't have the knowledge of Excel to make it work well.
In the meantime, I have found a nice piece of shareware (although a tad expensive I think) which does exactly what i want at
http://home.nycap.rr.com/aotw/timecalc.htm
If I can round to it, I might just get my logbook added up before the evaluation period is over
Thanks again folks
In the meantime, I have found a nice piece of shareware (although a tad expensive I think) which does exactly what i want at
http://home.nycap.rr.com/aotw/timecalc.htm
If I can round to it, I might just get my logbook added up before the evaluation period is over
Thanks again folks
The Oracle
Joined: Aug 2001
Posts: 2,902
Likes: 0
From: Naples, Florida U.S.A.
roundwego,
Before you spend any money on a program, try these free ones:
Time Calculator Pro 1.0
Minute by Minute 2.0
Take Care,
Richard
Before you spend any money on a program, try these free ones:
Time Calculator Pro 1.0
Minute by Minute 2.0
Take Care,
Richard
Plastic PPRuNer
Joined: Sep 2000
Posts: 1,902
Likes: 0
From: Rochechouart, France
No reflection on you roundwego, just a whimsical comment.
Time was, most people who used computers could program a bit and the core of such a program is only a few lines in QBasic (or even (gasp!) GW-Basic). Prettying it up and adding sanity checks and file I/O would add a bit but it's the sort of thing that used to amuse me for a few hours.
It just seems a shame to me that the complexity of modern OSs and languages means that the joys of simple programming are pretty much lost for the average guy now.
S'pose if I had to do it now I'd do it in Java, but I daresay one could even do it in batch (or use the wonderful but defunct BUILDER). Come to think about it, Clipper would do well too.
I'll crawl back into my cave now.....
Time was, most people who used computers could program a bit and the core of such a program is only a few lines in QBasic (or even (gasp!) GW-Basic). Prettying it up and adding sanity checks and file I/O would add a bit but it's the sort of thing that used to amuse me for a few hours.
It just seems a shame to me that the complexity of modern OSs and languages means that the joys of simple programming are pretty much lost for the average guy now.
S'pose if I had to do it now I'd do it in Java, but I daresay one could even do it in batch (or use the wonderful but defunct BUILDER). Come to think about it, Clipper would do well too.
I'll crawl back into my cave now.....
Joined: Dec 1998
Posts: 4,282
Likes: 6
From: Escapee from Ultima Thule
the information I posted in this thread will work for you. Use of the search facility would have found it.
http://www.pprune.org/forums/showthr...ighlight=hours
http://www.pprune.org/forums/showthr...ighlight=hours
Joined: Oct 2003
Posts: 1,300
Likes: 0
From: Canberra Australia
Hours & Minutes
Incredible that some of you are still recording flying time using minutes.
Way back in 1978 I was in a position in RAAF to decree that all times associated with aircraft and crew flying hours be recorded henceforth in decimal hours.
Banned Port and Starboard at same time having seen one of a section of 4 turn wrong way when on the receiving end of an enemy attack following a call "Break Port". Also overheard an airman ask his supervisor - Pilot has snagged the starboard engine. Which one is that."
Incredible that some of you are still recording flying time using minutes.
Way back in 1978 I was in a position in RAAF to decree that all times associated with aircraft and crew flying hours be recorded henceforth in decimal hours.
Banned Port and Starboard at same time having seen one of a section of 4 turn wrong way when on the receiving end of an enemy attack following a call "Break Port". Also overheard an airman ask his supervisor - Pilot has snagged the starboard engine. Which one is that."
Joined: Dec 1998
Posts: 4,282
Likes: 6
From: Escapee from Ultima Thule
Yeah. I haven't logged in hours & mins. since 1984 or so. The only reason I had to dohours & mins on the spreadsheet was because the mob I worked for in the UK still used it. I mentioned the higher error rate & increased time to process the data to the Flight Ops Director & he agreed the system has its faults. You wouldn't believe how many times those raw figures were copied from one form to another for different departments & purposes, each time increasing the chance of error in copying or processing. Talk about needlessly increased effort. 
