If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
"Wayne Paul" wrote in message ... "Peter Seddon" wrote in message OK try summing a few time that when added are greater than 24 hrs. Or put a time in of 45hrs 36mins and see what it does then. Peter Peter, I have been watching this thread and thought I would see what happens on my computer using Excel as delivered in Office 2000. Using the format Category of "Time" and the Type "37:20:55" I entered 12:22, 14:38, 72:14 and the above mentioned 45:36. Summing this column gave an accurate total of 144:50:00. What version of Excel are you using? Wayne, http://www.soaridaho.com/ I'm on 2003 but the format you selected is for mins and sec + one dec place of secs not hrs and mins Peter. |
#22
|
|||
|
|||
Go to the menu item Format Cells
Select the Custom Category (at the bottom of the menu on the left) Type the following into the 'Type' box in the upper right of the dialog: [h]:mm;@ This will give you the standard flight log format - hhh:mm (no seconds) This works in Excel 2003 - but I don't think the formats have changed much if at all since Excel '97 9B At 19:00 13 December 2004, Marc Ramsey wrote: Wayne Paul wrote: Using the format Category of 'Time' and the Type '37:20:55' I entered 12:22, 14:38, 72:14 and the above mentioned 45:36. Summing this column gave an accurate total of 144:50:00. What version of Excel are you using? I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be using the '37:30:55' time format in the Format Cells dialog. If any other time format is used, the values are interpreted as time of day, and wrap around at 24 hours. Marc |
#23
|
|||
|
|||
Peter Seddon wrote:
"Marc Ramsey" wrote in message I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be using the "37:30:55" time format in the Format Cells dialog. If any other time format is used, the values are interpreted as time of day, and wrap around at 24 hours. Marc I'm on excel 2003 and the 37:30:55 time format aint available to me. It is 99.9% likely that there is an equivalent in Excel 2003, as Microsoft never takes code out, they just add new features that nobody uses 8^). There are probably at least three distinct hh:mm:ss entries in the format dialog, one should work. Marc |
#24
|
|||
|
|||
Excell does work like that! ie for a flight of 8hrs 57min you put 8:57
You have to use the format including seconds at the one for just hrs:min will give you a false reading at higher values. I have entered my logbook for over 600 flights using this method and it works for me. OK try summing a few time that when added are greater than 24 hrs. Or put a time in of 45hrs 36mins and see what it does then. Peter Entered it, added it, it worked!!! Read and try it |
#25
|
|||
|
|||
You don't need Excel. Just go sailing on the Great Lakes in November.
They say that the waves turn the minutes to hours... Bob K. |
#26
|
|||
|
|||
"Andy Blackburn" wrote in message ... Go to the menu item Format Cells Select the Custom Category (at the bottom of the menu on the left) Type the following into the 'Type' box in the upper right of the dialog: [h]:mm;@ This will give you the standard flight log format - hhh:mm (no seconds) This works in Excel 2003 - but I don't think the formats have changed much if at all since Excel '97 9B At 19:00 13 December 2004, Marc Ramsey wrote: Wayne Paul wrote: Using the format Category of 'Time' and the Type '37:20:55' I entered 12:22, 14:38, 72:14 and the above mentioned 45:36. Summing this column gave an accurate total of 144:50:00. What version of Excel are you using? I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be using the '37:30:55' time format in the Format Cells dialog. If any other time format is used, the values are interpreted as time of day, and wrap around at 24 hours. Marc That one works a treat;-) Peter. |
#27
|
|||
|
|||
Using later versions of Excel highlight the column that you will use for
your time entries and then select the format of that column ( Format / Cells ) as 'Number' and select 'Custom' in the list box. In the 'type' box enter [hh]:mm ( where 'general' is displayed ) The column will now total properly. ie 14:00 15:00 10:00 =39:00 You have to enter hours as X: ie with the colon otherwise X is interpreted as X days - this can be picked up visually since the cell will display 24 * X if you enter just the X. minutes must be entered as 0:mm ie: with the leading zero otherwise the entry is simply ignored. Ian |
#28
|
|||
|
|||
"tango4" wrote in message ... Using later versions of Excel highlight the column that you will use for your time entries and then select the format of that column ( Format / Cells ) as 'Number' and select 'Custom' in the list box. In the 'type' box enter [hh]:mm ( where 'general' is displayed ) The column will now total properly. ie 14:00 15:00 10:00 =39:00 You have to enter hours as X: ie with the colon otherwise X is interpreted as X days - this can be picked up visually since the cell will display 24 * X if you enter just the X. minutes must be entered as 0:mm ie: with the leading zero otherwise the entry is simply ignored. Ian Yes I used that system and now my log book is workin perfectly on excel. Peter. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
millionaire on the Internet... in weeks! | Malcolm Austin | Soaring | 0 | November 5th 04 11:14 PM |
Excel formula for logbook | Wizard of Draws | Instrument Flight Rules | 11 | August 30th 04 12:55 AM |
"I Want To FLY!"-(Youth) My store to raise funds for flying lessons | Curtl33 | General Aviation | 7 | January 9th 04 11:35 PM |
AmeriFlight Crash | C J Campbell | Piloting | 5 | December 1st 03 02:13 PM |
AOPA Stall/Spin Study -- Stowell's Review (8,000 words) | Rich Stowell | Piloting | 25 | September 11th 03 01:27 PM |