Sponsor Message:
Non Aviation Forum
My Starred Topics | Profile | New Topic | Forum Index | Help | Search 
Excel Continuous Time Countup?  
User currently offlineJamesbuk From United Kingdom, joined May 2005, 3968 posts, RR: 4
Posted (7 years 2 months 2 weeks 4 days 8 hours ago) and read 1531 times:

Hey boys and squirls,

Im making a logbook on Excel (MS) for flight simulator hours. I need to format the cell so that once it gets to 24 hours it doesnt go back round and then go to 00:01 so i need it to be able to count above 24 hours. Is there a way I can do this? I tried formatting the cell but I cant find it in there.

rgds --James--


You cant have your cake and eat it... What the hells the point in having it then!!!
4 replies: All unread, jump to last
 
User currently offlineManuCH From Switzerland, joined Jun 2005, 3010 posts, RR: 48
Reply 1, posted (7 years 2 months 2 weeks 4 days 8 hours ago) and read 1531 times:
AIRLINERS.NET CREW
HEAD MODERATOR

Try doing a customized cell format, and enter [HHH]:mm ... it should work that way.


Never trust a statistic you didn't fake yourself
User currently offlineAeroWesty From United States of America, joined Oct 2004, 20322 posts, RR: 63
Reply 2, posted (7 years 2 months 2 weeks 4 days 8 hours ago) and read 1523 times:

Manu is correct, but I would go with: [h]:mm:ss

Then it will format it with the number of hours without any extraneous leading zeros.



International Homo of Mystery
User currently offlineManuCH From Switzerland, joined Jun 2005, 3010 posts, RR: 48
Reply 3, posted (7 years 2 months 2 weeks 4 days 8 hours ago) and read 1513 times:
AIRLINERS.NET CREW
HEAD MODERATOR

Quoting AeroWesty (Reply 2):
Manu is correct, but I would go with: [h]:mm:ss
Then it will format it with the number of hours without any extraneous leading zeros.

Right, I should have specified it... it's only that I like the leading zeros  Smile

Just leave out (or include) the ":ss" depending on whether you need seconds as well or not.



Never trust a statistic you didn't fake yourself
User currently offlineJamesbuk From United Kingdom, joined May 2005, 3968 posts, RR: 4
Reply 4, posted (7 years 2 months 2 weeks 4 days 7 hours ago) and read 1499 times:

Ah thank's guys! Worked a treat  Smile

Rgds --James--



You cant have your cake and eat it... What the hells the point in having it then!!!
Top Of Page
Forum Index

This topic is archived and can not be replied to any more.

Printer friendly format

Similar topics:More similar topics...
Tell Me All About Manila - Time To Get Rowdy! posted Wed Apr 11 2007 16:49:49 by 'Longreach'
Time For Another Weather Thread. posted Mon Apr 9 2007 08:33:34 by Jafa39
Song U Like, But Hate At The Same Time posted Mon Apr 9 2007 05:17:15 by BR076
2+ Computer Monitors At The Same Time... posted Sat Apr 7 2007 02:43:45 by Piercey
It's Now Time For Useful Trivia! posted Mon Apr 2 2007 03:19:34 by GAIsweetGAI
Abdullah Blows It Big Time For W. posted Wed Mar 28 2007 21:54:29 by TedTAce
It's Time For: Man Or Woman? posted Sun Mar 25 2007 20:34:54 by Thom@s
Is It Time To Start Planning The Spring YYZ Meet? posted Fri Mar 23 2007 02:26:39 by Lnglive1011yyz
Time For A Signed By Thread posted Thu Mar 22 2007 19:35:31 by Fiatstilojtd
Time To Say .... posted Mon Mar 19 2007 02:50:04 by Jycarlisle