Another alternative...
B1: =SUMPRODUCT(TIME(INT(A1:A10),MOD(A1:A10,1)*100,))

Regards,

Ron Coderre
Microsoft MVP (Excel)

"Ron Coderre" wrote in message
...
With
A1:A10 containing pseudo-times in the format hours-decimal_point-minutes
Example:
1.20 = 1 hour and 20 minutes
1.02 = 1 hours and 2 minutes

This formula sums those "times" and returns the result as proper time
B1 (formatted as time):
=SUMPRODUCT(--SUBSTITUTE(TEXT(A1:A10,"0.00"),".",":"))

Is that something you can work with?

"DR" wrote in message
...
Hi,

I have to fill the time sheet, in that i have to give activity name and
hours i worked on the activity.when I sum the total of hours i worked ,it
is
taking as normail No..Can i get any formula to covert it in to hours and
minuts

Ex : A1 activity i worked for 30mins (.30) , A2 activity I work... 1h.20
min
(1.20) , A3 - 1h .50m (1.50)

if I sum the total it had to show 3h.40min (but it is showing as 3 )

Can I get any formula for this ...?