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: Tugger, Yahoo [Bot] and 18 guests