Sponsor Message:
Aviation Hobby Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Flight Time Adding...  
User currently offlineDambuster From Switzerland, joined Nov 2006, 126 posts, RR: 0
Posted (6 years 2 months 2 weeks 5 days 9 hours ago) and read 5779 times:

Searched for this subject on a.net, don't believe it's been discussed before...
So here goes,
Some time ago I decided to start copying my logbook into excel, it all went fine by adding hours till 24 hours flight time... I read in the help menu that excel cannot calculate times more than 24 hours, so I've got a big problem on my hands, I know that at some point there'll be a mistake that'll ruin everything, so I'd love to know if you guys know a time adding tool, like you can add 2 hr 54 min to 78 hr 21 min.
Any ideas?
Thanks!

6 replies: All unread, jump to last
 
User currently offlineStarAlliance38 From United States of America, joined Jan 2008, 1445 posts, RR: 3
Reply 1, posted (6 years 2 months 2 weeks 5 days 7 hours ago) and read 5772 times:

Yeah, switch to FlightMemory Big grin




Roar, lion, roar
User currently offlineWILCO737 From Greenland, joined Jun 2004, 9077 posts, RR: 76
Reply 2, posted (6 years 2 months 2 weeks 5 days 1 hour ago) and read 5762 times:
AIRLINERS.NET CREW
HEAD MODERATOR



Quoting Dambuster (Thread starter):

I use an excel file for my real logbook. It is true it cannot calculate above 24 hours, but with a trick it can: just set it to 00:00:00 and then to the options somewhere it should say: 99:99:99. Then it can add above 24 hours.
So my excel file says for a 3hrs30min flight: 03:30:00. And all added up: 3256:46:00. You always have the last two digits with you although you don't need them, but that makes it possible to add above 24 hours.

WILCO737 (MD11F)
 airplane 



It it's not Boeing, I am not going.
User currently offlineDambuster From Switzerland, joined Nov 2006, 126 posts, RR: 0
Reply 3, posted (6 years 2 months 2 weeks 4 days 15 hours ago) and read 5747 times:

That sounds great, but I don't quite understand what I have to set to 00:00:00, like is the time format or something else? Where do I got to exactly, (which menu)? I have MS office 2007 if it helps...
Thanks very much for your help! Really made my happy to know it's possible with excel, thanks for the other tool as well Staralliance, I'll have a look at it too.  Smile


User currently offlineWILCO737 From Greenland, joined Jun 2004, 9077 posts, RR: 76
Reply 4, posted (6 years 2 months 2 weeks 4 days 12 hours ago) and read 5737 times:
AIRLINERS.NET CREW
HEAD MODERATOR



Quoting Dambuster (Reply 3):

The problem is I don't use MS2007, I use Staroffice and I use a German version  Wink

but i try to tell you where it is. There is one thing called FORMAT (German word) it is left of EXTRAS and there is a feature where you can change the preferences of this square where your mouse is in. In German it is called ZELLE (Cell). And you can adjust it in there. Then there you can change the type of how your times will be shown. You can chose between: percent, currency etc etc. There must be one thing called TIMES. Then on the right of it you have to shouce 876613:37:46 (that's the way it is called at StarOffice). And then you enter your flight time in 6 digits 02:45:00, means 2 hrs 45 mins 00 seconds. The seconds doesn't count, but you have to put them in to make it possible to go above the 24hrs etc.... then hit OK and it should be fine...

Sorry, this is the best I can explain it with my version...

WILCO737 (MD11F)
 airplane 



It it's not Boeing, I am not going.
User currently offlineDambuster From Switzerland, joined Nov 2006, 126 posts, RR: 0
Reply 5, posted (6 years 2 months 2 weeks 4 days 12 hours ago) and read 5736 times:

Hey, it's working! I went down the list and looked at the examples and surely enough I found what I was looking for! Awesome! Thanks very much for your help!
 Smile  bigthumbsup 


User currently offlineWILCO737 From Greenland, joined Jun 2004, 9077 posts, RR: 76
Reply 6, posted (6 years 2 months 2 weeks 4 days 10 hours ago) and read 5731 times:
AIRLINERS.NET CREW
HEAD MODERATOR



Quoting Dambuster (Reply 5):
Thanks very much for your help!

Awesome  Wink I wasn't sure if you'll understand my weird explanation  Wink

Have fun and enjoy.

WILCO737 (MD11F)
 airplane 



It it's not Boeing, I am not going.
Top Of Page
Forum Index

Reply To This Topic Flight Time Adding...
Username:
No username? Sign up now!
Password: 


Forgot Password? Be reminded.
Remember me on this computer (uses cookies)
  • Aviation hobby related posts only.
  • Back all your opinions with facts.
  • No adverts of any kind. This includes web pages.
  • No hostile language or criticizing of others.
  • Do not post copyright protected material.
  • Use relevant and describing topics.
  • Check if your post already been discussed.
  • Check your spelling!
  • DETAILED RULES
Add Images Add SmiliesPosting Help

Please check your spelling (press "Check Spelling" above)


Similar topics:More similar topics...
Your Longest Flight Time In FS2002 posted Tue May 28 2002 21:18:25 by Frequentflyer5
Adding AI Traffic/flight Plans posted Mon Mar 26 2007 22:01:07 by Ebs757
Adding Buildings To Flight Simulator posted Sun Jun 18 2006 23:39:51 by Btriple7
Flight Sim Landing Time Of Day posted Wed May 17 2006 21:17:27 by Jamesbuk
Playstation Flight SIm Versus Real Time? posted Sun Jun 12 2005 19:40:10 by Wardialer
Real Time Flight Tracking posted Fri Feb 4 2005 19:44:52 by PDXFlyer
Real Time Air Traffic For Flight Simulator posted Sat Dec 18 2004 16:58:56 by Concord977
Longest Flight, Longest On Time Flight Arrival! posted Fri Nov 15 2002 19:46:55 by Propilot83
How To Write AI Flight Plans With Touch And Gos posted Thu Aug 7 2008 16:01:46 by Elcableguy77
Boston Flight Schools posted Sat Jul 26 2008 14:26:30 by A340Crew

Sponsor Message:
Printer friendly format