Excel Formula minutes convert to hours

"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.