Log Book Calc
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).
Join Date: Aug 2006
Location: North of Watford Gap
Age: 38
Posts: 58
Likes: 0
Received 0 Likes
on
0 Posts
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!
Join Date: Jan 2006
Location: on the move ...
Posts: 121
Likes: 0
Received 0 Likes
on
0 Posts
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.
Join Date: Sep 2006
Location: As far away from work as possible
Posts: 87
Likes: 0
Received 0 Likes
on
0 Posts
There was a great logbook gizza at Valley, think it was called "Smorth's Logbook Gizza", perhaps someone from the island of dreams could PM it to you.