Logbook Calculator
Thread Starter
Logbook Calculator
Hi All
Just a quick one...does anyone have a program used for the addition of time, to aid in the old logbook fiasco at the end of every month.
I've seen one at Colt before but believe the IT section took it off all computers.
Thanks
TF
PS. I'm not just wondering who has a copy, I would actually appreciate a copy of the program too.
Just a quick one...does anyone have a program used for the addition of time, to aid in the old logbook fiasco at the end of every month.
I've seen one at Colt before but believe the IT section took it off all computers.
Thanks
TF
PS. I'm not just wondering who has a copy, I would actually appreciate a copy of the program too.
(a bear of little brain)
Join Date: Aug 2001
Location: 51 10 03.70N 2 58 37.15W
Age: 75
Posts: 273
Likes: 0
Received 0 Likes
on
0 Posts
You can do time adding up in Excel, as follows:-
1. Open an Excel spreadsheet.
2. Format the row in time format (hh:mm if just minutes, hh:mm:ss if times include seconds).
3. Type your times into the boxes in the column.
4. Click on the first empty box at the end of the column.
5. Click the 'total' button (the Sigma sign). A formula will appear.
6. Hit tab.
As if by magic the total will appear. (It's how I do my timesheets).
Hope this helps (if you have any questions please PM me).
Edited because I forgot. If you are using XP the total will omit whole days (e.g. if the total time should be 27:40:15 it will show as 3:40:15). Annoying and I haven't figured a way round that yet but should be fairly obvious.
1. Open an Excel spreadsheet.
2. Format the row in time format (hh:mm if just minutes, hh:mm:ss if times include seconds).
3. Type your times into the boxes in the column.
4. Click on the first empty box at the end of the column.
5. Click the 'total' button (the Sigma sign). A formula will appear.
6. Hit tab.
As if by magic the total will appear. (It's how I do my timesheets).
Hope this helps (if you have any questions please PM me).
Edited because I forgot. If you are using XP the total will omit whole days (e.g. if the total time should be 27:40:15 it will show as 3:40:15). Annoying and I haven't figured a way round that yet but should be fairly obvious.
Join Date: Mar 2004
Location: valley
Posts: 4
Likes: 0
Received 0 Likes
on
0 Posts
dude - if you want a prog to do all the easy, (but easy to mess up!) work for you, drop me a line with a clue to your email on this post, and I'll email it to you, or do some of that fancy PM stuff (never done it myslef, so don't know how it works...). We've got a little gizza calles 'Smorth's logbook calculator' here at Valley, and - let me tell you - the man Smorth is a genius...!!
Join Date: Mar 2003
Location: UK
Posts: 106
Likes: 0
Received 0 Likes
on
0 Posts
Hell, have both programs, go crazy!
Good old Smorth's still going strong then? The man of a thousand gizzas!
Aha, managed to get it on the web.
Hours Adder
Hope this helps.
Good old Smorth's still going strong then? The man of a thousand gizzas!
Aha, managed to get it on the web.
Hours Adder
Hope this helps.
Join Date: Dec 1997
Location: Suffolk UK
Posts: 4,927
Likes: 0
Received 0 Likes
on
0 Posts
In Excel, to add times without getting screwed up by days etc, use the custom time format [HH:mm], and apply it to all cells used for recording and calculating hours. This will do the necessary for you.
Join Date: Feb 2004
Location: Lyneham
Posts: 45
Likes: 0
Received 0 Likes
on
0 Posts
One from the network at Lyneham - looks like the standard windows calculator and includes a 'till roll' thing if you leave your cursor hovering over the calculator's display. Don't know who wrote it, but whoever it was - thanks!
Hours and Minutes Calculator
Hours and Minutes Calculator
Join Date: Mar 2003
Location: Down South
Posts: 15
Likes: 0
Received 0 Likes
on
0 Posts
Sad I know, but I am no computer geek okay.
In Excel, Go Format, Cells, Number then select custom. Once in custom select hh:mm, then change it to this [h]:mm, this will total the hours as opposed to converting them to days with the other option.
Who said an Opsy aint good for anything eh
In Excel, Go Format, Cells, Number then select custom. Once in custom select hh:mm, then change it to this [h]:mm, this will total the hours as opposed to converting them to days with the other option.
Who said an Opsy aint good for anything eh
My Texas Instruments DMS : DD function has been just the ticket for the last 18 years!
Amazed that you guys get the chance to fly often enough these days to need to use a calculator at all.
Top tip - keep your log book away from the sqn and enter your trip times on the same day. Then you won't have to fight for the auth sheets at the end of the month!! The biggest log book snags come from waiting for some minor cog to cross-check them and then waiting for them to come back after some wheel has signed them.
Amazed that you guys get the chance to fly often enough these days to need to use a calculator at all.
Top tip - keep your log book away from the sqn and enter your trip times on the same day. Then you won't have to fight for the auth sheets at the end of the month!! The biggest log book snags come from waiting for some minor cog to cross-check them and then waiting for them to come back after some wheel has signed them.
Join Date: Dec 2003
Location: U.K
Posts: 22
Likes: 0
Received 0 Likes
on
0 Posts
Try this
http://www.662sqn.com/
It's in the downloads section. I know it say's Lynx and Gazelle but it seems to work for all others. If not the chap seems quite keen to help out. Infact Army type blokey more than likely copied it from the better service anyway.
It's in the downloads section. I know it say's Lynx and Gazelle but it seems to work for all others. If not the chap seems quite keen to help out. Infact Army type blokey more than likely copied it from the better service anyway.
Join Date: Apr 2004
Location: Erehwon
Posts: 1,146
Likes: 0
Received 0 Likes
on
0 Posts