Chris Kaminski wrote:
At 12:00 12 December 2004, Mal wrote:

Hi does anyone know the formula for excel so it will
add the minutes after the decimal and convert them

to hours.

format the cells to h:mm
you can also format to hh:mm
or even to hh:mm:ss
when adding two cells is likely to lead to hours in
excess of 9
format [hh]:mm otherwise the sum will go wrong

enter the times as 1:27 (1 hour 27 min)
best rgrds Chris

What is VERY annoying with that solution is that you
cannot enter flights less than one hour by simply
writing the number of minutes.

Eg. for a 23 minute flight you actually _have_ to
write 0:27 which means you have to press four keys
instead of two.

CV