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