jamesbuk
Posts: 3712
Joined: Mon May 02, 2005 11:52 pm

Excel Continuous Time Countup?

Wed Apr 25, 2007 1:07 am

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!!!
 
User avatar
ManuCH
Crew
Posts: 2679
Joined: Mon Jun 20, 2005 12:33 am

RE: Excel Continuous Time Countup?

Wed Apr 25, 2007 1:10 am

Try doing a customized cell format, and enter [HHH]:mm ... it should work that way.
Never trust a statistic you didn't fake yourself
 
AeroWesty
Posts: 19551
Joined: Sat Oct 30, 2004 7:37 am

RE: Excel Continuous Time Countup?

Wed Apr 25, 2007 1:12 am

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 avatar
ManuCH
Crew
Posts: 2679
Joined: Mon Jun 20, 2005 12:33 am

RE: Excel Continuous Time Countup?

Wed Apr 25, 2007 1:36 am

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
 
jamesbuk
Posts: 3712
Joined: Mon May 02, 2005 11:52 pm

RE: Excel Continuous Time Countup?

Wed Apr 25, 2007 2:36 am

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!!!

Who is online

Users browsing this forum: AirplaneWizard, BlueberryWheats, Hillis, scbriml and 1 guest

Popular Searches On Airliners.net

Top Photos of Last:   24 Hours  •  48 Hours  •  7 Days  •  30 Days  •  180 Days  •  365 Days  •  All Time

Military Aircraft Every type from fighters to helicopters from air forces around the globe

Classic Airliners Props and jets from the good old days

Flight Decks Views from inside the cockpit

Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior

Cargo Aircraft Pictures of great freighter aircraft

Government Aircraft Aircraft flying government officials

Helicopters Our large helicopter section. Both military and civil versions

Blimps / Airships Everything from the Goodyear blimp to the Zeppelin

Night Photos Beautiful shots taken while the sun is below the horizon

Accidents Accident, incident and crash related photos

Air to Air Photos taken by airborne photographers of airborne aircraft

Special Paint Schemes Aircraft painted in beautiful and original liveries

Airport Overviews Airport overviews from the air or ground

Tails and Winglets Tail and Winglet closeups with beautiful airline logos