Adding Time
Thread Starter
Joined: Feb 2003
Posts: 420
Likes: 0
From: Io
Adding Time
I don't like to admit it, but I'm absolutely useless at adding time. When I come to totalling up the log book it takes me ages to get it right. Does anyone know of any software (cheap or free if poss) that can do this? maybe even a macro for excel?
Many thanks
Thicko
Many thanks
Thicko
Joined: Dec 2001
Aviation Qualifications: Military
Posts: 1,286
Likes: 20
From: I have no idea but the view's great.
Wish that I had enough money to need a calculator to add up the time that I do.
However, either search the Military Aircrew forum with the words - hours calculator - or send me a PM and I'll email you a couple of different ones.
However, either search the Military Aircrew forum with the words - hours calculator - or send me a PM and I'll email you a couple of different ones.
Moderator
Joined: Feb 2000
Aviation Qualifications: CPL
Posts: 14,480
Likes: 178
From: UK
Casio Fx-83 scientific calculator, about £8 from office world will do it (or their more expensive ones, but this does most things).
If you are using MS Excel, use two separate columns for hours and minutes, and a bit of judicious arithmetic in the totals column - easily done.
G
If you are using MS Excel, use two separate columns for hours and minutes, and a bit of judicious arithmetic in the totals column - easily done.
G
Joined: Feb 2002
Posts: 2,547
Likes: 0
From: Dublin
I find the simplist way is to add everything on my calculator in minutes.
ie. Take whole number of hours brought forward onto the page (ignore the minutes), and to it the whole number of hours flown on that page (ignore the minutes), then multiply that answer by 60, to convert that to minutes.
Then go back and add to that sum, the minutes brought forward to that page, and add the minutes flown on that page.
You now have your total time in minutes. So just divide that by 60, to get the hours. This gives you the whole hours flown to date. Subtract the whole hours, and you will be left with everything after the decimal point. Multiply this by 60, to get the minutes part of the total.
No special calculator needed, and simple and easy to do
Hope that helps!
dp
ie. Take whole number of hours brought forward onto the page (ignore the minutes), and to it the whole number of hours flown on that page (ignore the minutes), then multiply that answer by 60, to convert that to minutes.
Then go back and add to that sum, the minutes brought forward to that page, and add the minutes flown on that page.
You now have your total time in minutes. So just divide that by 60, to get the hours. This gives you the whole hours flown to date. Subtract the whole hours, and you will be left with everything after the decimal point. Multiply this by 60, to get the minutes part of the total.
No special calculator needed, and simple and easy to do
Hope that helps!
dp
Carbonfibre-based lifeform
Joined: Mar 2002
Posts: 747
Likes: 0
From: London
If you are using MS Excel, use two separate columns for hours and minutes, and a bit of judicious arithmetic in the totals column - easily done.
In order to make sure it deals with totals exceeding 24 hours you need to set the cell format to [hh]:mm using Format Cells/Custom.
Or try this Excel spreadsheet.
Right-click on that link and save it to your machine. It adds up your hours, keeps track of what you\'ve done in the last 90 days etc.
Last edited by Fly Stimulator; 29th July 2004 at 22:36.
The Original Whirly
Joined: Feb 1999
Aviation Qualifications: CPL
Posts: 4,327
Likes: 2
From: Belper, Derbyshire, UK
Well, and there was I all innocently thinking that we ALL use decimal time...because like Tinstaafl, that's what I've always done. Makes life a lot easier, and saves buying fancy calculators. 
Carbonfibre-based lifeform
Joined: Mar 2002
Posts: 747
Likes: 0
From: London
Well, and there was I all innocently thinking that we ALL use decimal time...
It seems to me that the mathematical challenges of both methods are roughly equivalent anyway. Converting minutes into fractions of an hour so you can enter them that way taxes the brain as much (or indeed as little) as adding hours and minutes together.
Six of one and half-a-dozen of the other!
wbryce - see the link above!
Joined: Mar 2003
Posts: 152
Likes: 0
From: SE England
Any scientific calculator with the button with commas on it
type in hours first press the comma button, then the minutes followed by the comma button and the + and continue putting in time using the comma button.
If its something like 30 mins input 0'30' etc.
type in hours first press the comma button, then the minutes followed by the comma button and the + and continue putting in time using the comma button.
If its something like 30 mins input 0'30' etc.
Joined: Jun 2002
Posts: 743
Likes: 1
From: Kilmacolm
The tried and tested method I use is the same as someone else above...
I add all of my times up in minutes and then divide by sixty. Take away the whole number (hours) and then muliple the remainder by 60 to give me minutes.
I usually enter my times the the nearest 5 minutes (give or take) so it works out pretty well.
Takes a bit of time, especially with all of the columns being used now!!!
Best wishes,
Charlie Zulu.
I add all of my times up in minutes and then divide by sixty. Take away the whole number (hours) and then muliple the remainder by 60 to give me minutes.
I usually enter my times the the nearest 5 minutes (give or take) so it works out pretty well.
Takes a bit of time, especially with all of the columns being used now!!!
Best wishes,
Charlie Zulu.
Joined: Jun 2000
Posts: 185
Likes: 0
From: Co.Durham UK
I did one on Excel which was really straightforward even for a complete incompetent which I am! I would email it to you but my desktop which it is on is poorly. Always remember to back those files up....doh!
Joined: May 2001
Posts: 4,729
Likes: 0
From: 75N 16E
Blimey........
Well, here's a trick. Take time, and turn it into a decimal. 1hr = 1.0, 6 minutes = 0.1 etc (you get my drift). Do the maths, then if you feel the urge, convert it back to "normal" time. I just log it as decimal time, as I like an easy life, and the CAA / FAA don't have a problem with me doing it.....
Well, here's a trick. Take time, and turn it into a decimal. 1hr = 1.0, 6 minutes = 0.1 etc (you get my drift). Do the maths, then if you feel the urge, convert it back to "normal" time. I just log it as decimal time, as I like an easy life, and the CAA / FAA don't have a problem with me doing it.....
Joined: Aug 2000
Posts: 2,681
Likes: 10
From: Just South of the last ice sheet
What's the big deal? Ignore the hours, add up the minutes and divide by 60 you get hours and minutes. Add up the hours and add to the hours total from the previous calculation. Surely it's only a pain if you haven;t bothered to add up the pages for a while. I make a point of adding up each page as I fill it in now after spending a boring hour playing catch-up once.
Joined: Mar 2001
Posts: 409
Likes: 0
From: Costa Del Solent
Am I the only one that just adds up normally?
I write down all of the times in a column as if I were adding any ordinary set of numbers. I start by adding the minutes. Every time I get to 10, I add 1 to the ten's of minutes column.
In the ten's of minutes column, every time I get to 6 I add 1 to the hours column. Takes no time at all.
Hardly rocket science!!!
Crikey
I write down all of the times in a column as if I were adding any ordinary set of numbers. I start by adding the minutes. Every time I get to 10, I add 1 to the ten's of minutes column.
In the ten's of minutes column, every time I get to 6 I add 1 to the hours column. Takes no time at all.
Hardly rocket science!!!
Crikey
Joined: May 1999
Aviation Qualifications: ATP+Mil
Posts: 27,400
Likes: 857
From: Quite near 'An aerodrome somewhere in England'
DMS
D function on the calculator which I bought 18 years ago!
Decimal time? Nope, never used that. The Army used to, I gather, but have come round to using duodecimal now.
Alternatively, use Trislander's method!
D function on the calculator which I bought 18 years ago!Decimal time? Nope, never used that. The Army used to, I gather, but have come round to using duodecimal now.
Alternatively, use Trislander's method!
Joined: Feb 2003
Posts: 1,486
Likes: 7
From: Darwin
I started logging using hours and minutes, as that was how my first flying school logged.
Changing schools, they used hours and tenths of hours, which just made more sense to me to use.
It surely adds up easier, and because you round, you are rounding UP, which actually squeezes a little bit more time out of the aircraft. It works out that I might gain an extra three or four minutes out of a flight at times.
Also, the Aviation Theory Centre logbooks have a table inside the front cover to convert minutes to tenths of a hour; saves brainwork after landing. If your logbook doesnt have this, spend five minutes one rainy day writing one up inside your own logbook's cover.
Every six minutes you get another point one of an hour.
Changing schools, they used hours and tenths of hours, which just made more sense to me to use.
It surely adds up easier, and because you round, you are rounding UP, which actually squeezes a little bit more time out of the aircraft. It works out that I might gain an extra three or four minutes out of a flight at times.
Also, the Aviation Theory Centre logbooks have a table inside the front cover to convert minutes to tenths of a hour; saves brainwork after landing. If your logbook doesnt have this, spend five minutes one rainy day writing one up inside your own logbook's cover.
Every six minutes you get another point one of an hour.
