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

One way is to put hours in one cell and minutes in the other and then
convert all to minutes in a non-displayed cell [(hours X 60) + minutes]. At the
bottom of the page you add together all of the minutes and then convert back to
hours and minutes by using the interger (INT) function. To get the hours, use
the formula [Int (minutes/60)] =hours. To recover the fraction of an hour in
minutes, multiply the hours (from the previous formula) times 60 and then
subtract from the minutes.

Clear as mud?

Vaughn


Need to check my log book times and make a database off information types
flown etc.

EG

1.33
1.56
=2.89

Needs to say 60 mins is one hour

so

1.33
1.56
=3.29

???????????????

=SUM(E1:E23)


=IF(A31000,TIMEVALUE(LEFT(A3,1)&":"&RIGHT(A3,2)),T IMEVALUE(LEFT(A3,2)&":"&RIGHT(
A3,2)))
The formatting of the cells in column B is HH:MM.

Thanks Mal