"CV" wrote in message
...
Mal wrote:
Hi does anyone know the formula for excel so it will add the minutes
after
the decimal and convert them to hours.

I found it easier to do hours and minutes in separate Excel columns.

Say J is the hours column and K is minutes for each entry.

Then we sum up total hours, including decimal fractions of hours,
in a hidden L column:

L10=L9+J10+K10/60

(note: L9 was the previous total, before this entry)

Then the total time in hours and minutes is represented in
column M (hours) and N (minutes) respectively:

M10=INTEGER(L10)
N10=L10*60-M10*60

Cheers CV
At the risk of being too trivial, if the figures are already input, can
split them by:

say hour:mins in A1, put B1=INT(A1) (gives hours in B1), C1=(A1-B1)*100
(gives minutes in C1)

Keith