Log Book Calc
Joined: Aug 2006
Posts: 4,914
Likes: 659
From: West Sussex
I to have always used DB's recommendation, plus a calculator. The combined system might be known as the "floating hundreds" one, and was taught to me by a Nav (they used to do numbers). Enter each time with an extra "0" between the hours and minutes, i.e. 1hr 32mins enters as 1032. Thus:
1hr32mins+5hr17min+7hr21min+13hr37min+2hr19min+14hr05mins becomes
1032+5017+7021+13037+2019+14005=42131.
i.e. 42hr+131mins=42hr+2hr11mins=44hr11min.
It is easier than my clumsy explanation makes it appear, and means only one minutes to hour conversion per calculation is required. Obviously it doesn't work beyond 999mins, but has always sufficed in doing page summaries in the log book (seven in my case as well).
1hr32mins+5hr17min+7hr21min+13hr37min+2hr19min+14hr05mins becomes
1032+5017+7021+13037+2019+14005=42131.
i.e. 42hr+131mins=42hr+2hr11mins=44hr11min.
It is easier than my clumsy explanation makes it appear, and means only one minutes to hour conversion per calculation is required. Obviously it doesn't work beyond 999mins, but has always sufficed in doing page summaries in the log book (seven in my case as well).
Joined: Aug 2006
Posts: 58
Likes: 0
From: North of Watford Gap
Almost every elementary scientific calculator (such as needed for GCSE's!) has an hours, minutes, seconds function, which appears as a button marked with an apostrophe and a quotation mark. Costs about £7 from (for example) WH Smiths.
Not sure I'd be willing to spend that much though, especially when the sums shouldn't take more than 3 or 4 minutes anyway, using DaveyBoy's tried and tested method!
Not sure I'd be willing to spend that much though, especially when the sums shouldn't take more than 3 or 4 minutes anyway, using DaveyBoy's tried and tested method!
Joined: Jan 2006
Posts: 121
Likes: 0
From: on the move ...
Spaulding,
I have devised a logbook spreadsheet for my own use. It has some time calc in it that takes a time entered as a normal decimal (1.50 for one hour fifty mins) and converts it all to minutes, tot's it up and displays a running total in the column header in the format xxxxhxx (ie, 125h35)
There are no bells and whistles, and it hasn't had a great deal of testing as yet, but it gives you a vague idea how to do the time calc.
PM me if you would like a copy and I'll gladly email it to you.
I have devised a logbook spreadsheet for my own use. It has some time calc in it that takes a time entered as a normal decimal (1.50 for one hour fifty mins) and converts it all to minutes, tot's it up and displays a running total in the column header in the format xxxxhxx (ie, 125h35)
There are no bells and whistles, and it hasn't had a great deal of testing as yet, but it gives you a vague idea how to do the time calc.
PM me if you would like a copy and I'll gladly email it to you.
