time formatting in cells

[lefty]

Hi, I am a pilot trying to create a logbook to keep track of my flying
hours. Is excel the best programme to use to do this?

At the moment I am using a basic sum function to add the hours up but
when the total gets above 12 I get #### in the function cell. The
format keeps reverting to 2:12:00am for example. I think the programme
logic won't add time up past 12 hours.

How can I make it add up time values without it thinking they are clock
times?? I've tried the time format 37:55 but that doesn't seem to
work. thanks

 

[Bernard Rey]

Do you mean you picked the "37:30:55" format? That should work the way you
want it to. Or you can "manually" set the cell format to "[h]:mm" and it
will (should) give the same result.


--
Bernard Rey - Toulouse / France
MVP - office:macintosh http://faq.office.macintosh.free.fr



lefty :

 

[lefty]

Thank you both very much. You're both correct. I first widened the
column width and that got rid of the hashes, and I checked both formats
and both worked the way I wanted them to.

Now I just have to enter 10 years worth of data.

A question for later on though, if you don't mind. Is XL capable of
identifying certain cells; for example all flying I've done in 767's
and providing me a total for just that flying?? Is that what
conditional formatting is for?? Or will I just have to highlight every
767 cell??

thanks for your help.

lefty.

 

[Bob Greenblatt]

Thank you both very much. You're both correct. I first widened the
column width and that got rid of the hashes, and I checked both formats
and both worked the way I wanted them to.

Now I just have to enter 10 years worth of data.

A question for later on though, if you don't mind. Is XL capable of
identifying certain cells; for example all flying I've done in 767's
and providing me a total for just that flying?? Is that what
conditional formatting is for?? Or will I just have to highlight every
767 cell??

thanks for your help.

lefty.

That is not really what conditional formatting is for; and you will not have
to highlight every cell. What you want to do is look in help for the SUMIF
function. Once you have entered all your times, you should do an advanced
filter to extract the unique types of aircraft. Then build a list sumif
functions to calculate the totals by type. Keep asking here, and we can
help. (I'm a pilot also.)